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.

Item	Default value	Changeable
Collection Interval	600	Y
Collection Offset	75	Y
Log	No	Y
LOGIF	(Blank)	Y

• PD_PDOC_SID
• PD_PDOC_ADDRHASH

From the opening to the closing of the cursor

• Fixed part: 935 bytes
• Variable part: 184 bytes

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