The Transaction Lock (PD_PDTL) record stores performance data indicating the status (at a specific point in time) of transaction locks. PFM - RM for Oracle creates one record for each lock held by each transaction. This is a multi-instance record.

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

PD_PDTL_XID

From the locking to the unlocking of an object

• Fixed part: 935 bytes
• Variable part: 180 bytes

PFM - View name (PFM - Manager name)	Description	Summary	Format	Delta	Supported version	Data source
Locked Mode (LOCKED_MODE)	Lock mode	--	string(20)	No	All	V$LOCKED_OBJECT.LOCKED_MODE
Object Name (OBJECT_NAME)	Name of the locked object	--	string(30)	No	All	DBA_OBJECTS.OBJECT_NAME where DBA_OBJECTS.OBJECT_ID = V$LOCKED_OBJECT.OBJECT_ID
Object Type (OBJECT_TYPE)	Object type	--	string(30)	No	All	DBA_OBJECTS.OBJECT_TYPE where DBA_OBJECTS.OBJECT_ID = V$LOCKED_OBJECT.OBJECT_ID
Owner (OWNER)	Owner of the object	--	string(30)	No	All	DBA_OBJECTS.OWNER where DBA_OBJECTS.OBJECT_ID = V$LOCKED_OBJECT.OBJECT_ID
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 PDTL)	--	string(4)	No	All	Remote Monitor Collector
SID (SID)	Session ID	--	ulong	No	All	V$LOCKED_OBJECT.SESSION_ID
Start Time (START_TIME)	Collection start time for the performance data stored in the record	--	time_t	No	All	Remote Monitor Collector
User (USER_NAME)	Oracle user name	--	string(30)	No	All	V$LOCKED_OBJECT.ORACLE_USERNAME
VA DeviceID (VADEVICEID)	Device ID of virtual agent.	--	string(256)	No	All	Remote Monitor Collector
XID (XID)	Undo segment number, slot number, and sequence number. When a transaction is not running, 000 is set for this field.	--	string(30)	No	All	V$LOCKED_OBJECT.XIDUSN + V$LOCKED_OBJECT.XIDSLOT + V$LOCKED_OBJECT.XIDSQN