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

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset75Y
LogNoY
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)
DescriptionSummaryFormatDeltaSupported versionData source
Addrhash
(ADDRHASH)
Character string that identifies the SQL statement being executed--string(38)NoAllV$OPEN_CURSOR.ADDRESS + V$OPEN_CURSOR.HASH_VALUE
Program
(PROGRAM)
Name of the program being executed--string(48)NoAllV$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_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDOC)--string(4)NoAllRemote Monitor Collector
SID
(SID)
Session ID--ulongNoAllV$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)NoAllV$OPEN_CURSOR.SQL_TEXT
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
User
(USERNAME)
Oracle user name--string(30)NoAllV$SESSION.USERNAME where V$OPEN_CURSOR.SID = V$SESSION.SID
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector