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
Item | Default value | Changeable |
---|---|---|
Collection Interval | 600 | Y |
Collection Offset | 140 | Y |
Log | No | Y |
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) | 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 |