Open Cursor (PD_PDOC)
Function
The Open Cursor (PD_PDOC) record stores performance data indicating the status (at a specific point in time) of cursors. PFM - RM for Oracle creates one record for each open cursor in the system. This is a multi-instance record.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 600 | Y |
Collection Offset | 75 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key fields
Lifetime
From the opening to the closing of the cursor
Record size
Fields
PFM - View name (PFM - Manager name) | Description | Summary | Format | Delta | Supported version | Data source |
---|---|---|---|---|---|---|
Addrhash (ADDRHASH) | Character string that identifies the SQL statement being executed | -- | string(38) | No | All | V$OPEN_CURSOR.ADDRESS + V$OPEN_CURSOR.HASH_VALUE |
Program (PROGRAM) | Name of the program being executed | -- | string(48) | No | All | V$SESSION.PROGRAM where V$OPEN_CURSOR.SID = V$SESSION.SID |
Record Time (RECORD_TIME) | Collection termination time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record name (always PDOC) | -- | string(4) | No | All | Remote Monitor Collector |
SID (SID) | Session ID | -- | ulong | No | All | V$SESSION.SID where V$OPEN_CURSOR.SID = V$SESSION.SID |
SQL Text (SQL_TEXT) | First 60 characters of the SQL statement that is analyzed by the open cursor | -- | string(60) | No | All | V$OPEN_CURSOR.SQL_TEXT |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
User (USERNAME) | Oracle user name | -- | string(30) | No | All | V$SESSION.USERNAME where V$OPEN_CURSOR.SID = V$SESSION.SID |
VA DeviceID (VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | All | Remote Monitor Collector |