Transaction Lock (PD_PDTL)

Function

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.

Default and changeable values

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset140Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

PD_PDTL_XID

Lifetime

From the locking to the unlocking of an object

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Locked Mode
(LOCKED_MODE)
Lock mode--string(20)NoAllV$LOCKED_OBJECT.LOCKED_MODE
Object Name
(OBJECT_NAME)
Name of the locked object--string(30)NoAllDBA_OBJECTS.OBJECT_NAME where DBA_OBJECTS.OBJECT_ID = V$LOCKED_OBJECT.OBJECT_ID
Object Type
(OBJECT_TYPE)
Object type--string(30)NoAllDBA_OBJECTS.OBJECT_TYPE where DBA_OBJECTS.OBJECT_ID = V$LOCKED_OBJECT.OBJECT_ID
Owner
(OWNER)
Owner of the object--string(30)NoAllDBA_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_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDTL)--string(4)NoAllRemote Monitor Collector
SID
(SID)
Session ID--ulongNoAllV$LOCKED_OBJECT.SESSION_ID
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
User
(USER_NAME)
Oracle user name--string(30)NoAllV$LOCKED_OBJECT.ORACLE_USERNAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote 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)NoAllV$LOCKED_OBJECT.XIDUSN + V$LOCKED_OBJECT.XIDSLOT + V$LOCKED_OBJECT.XIDSQN