Transaction (PD_PDTR)
Function
The Transaction (PD_PDTR) record stores performance data indicating the status (at a specific point in time) of transactions. PFM - RM for Oracle creates one record for each transaction. This is a multi-instance record.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 600 | Y |
Collection Offset | 145 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key fields
Lifetime
From the start to the end of a transaction
Record size
Fields
PFM - View name (PFM - Manager name) | Description | Summary | Format | Delta | Supported version | Data source |
---|---|---|---|---|---|---|
Address (ADDRESS) | Address of the transaction status object | -- | string(16) | No | All | V$TRANSACTION.ADDR |
Cache Hit % (CACHE_HIT_PERCENTAGE) | Cache hit rate | -- | double | No | All | ((V$TRANSACTION.LOG_IO - V$TRANSACTION.PHY_IO) / V$TRANSACTION.LOG_IO) * 100 |
Consistent Change % (CONSISTENT_CHANGE_PERCENTAGE) | Percentage indicating the extents used for consistency in transaction read operations | -- | double | No | All | (V$TRANSACTION.CR_CHANGE / V$TRANSACTION.CR_GET) * 100 |
Consistent Changes (CONSISTENT_CHANGES) | Number of consistent changes | -- | double | No | All | V$TRANSACTION.CR_CHANGE |
Consistent Gets (CONSISTENT_GETS) | Number of consistent acquisitions | -- | double | No | All | V$TRANSACTION.CR_GET |
Locks (LOCKS) | Number of transaction locks | -- | double | No | All | COUNT(V$LOCKED_OBJECT) |
Logical I/O (LOGICAL_IO) | Logical I/O | -- | double | No | All | V$TRANSACTION.LOG_IO |
No Undo (NO_UNDO) | Identifier of a non-UNDO transaction. For a non-UNDO transaction, the value of this field is Yes. For an UNDO transaction, the value is No. | -- | string(3) | No | All | V$TRANSACTION.NOUNDO |
Physical I/O (PHYSICAL_IO) | Physical I/O | -- | double | No | All | V$TRANSACTION.PHY_IO |
Previous XID (PREVIOUS_XID) | Parent transaction ID | -- | string(30) | No | All | V$TRANSACTION.PRV_XIDUSN + V$TRANSACTION.PRV_XIDSLT + V$TRANSACTION.PRV_XIDSQN |
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 PDTR) | -- | string(4) | No | All | Remote Monitor Collector |
Recursive (RECURSIVE) | Identifier of a recursive transaction. For a recursive transaction, the value of this field is Yes. For a non-recursive transaction, the value is No. | -- | string(3) | No | All | V$TRANSACTION.RECURSIVE |
SID (SID) | Session ID | -- | ulong | No | All | V$SESSION.SID where V$TRANSACTION.SES_ADDR = V$SESSION.ADDR |
Space (SPACE) | Identifier of a space transaction. For a space transaction, the value of this field is Yes. For a non-space transaction, the value is No. | -- | string(3) | No | All | V$TRANSACTION.SPACE |
Start Time (START_TIME) | Collection start time for the performance data stored in the record | -- | time_t | No | All | Remote Monitor Collector |
Status (STATUS) | Transaction status | -- | string(16) | No | All | V$TRANSACTION.STATUS |
Tran Secs (TRANS_SECS) | Number of seconds since the start time | -- | ulong | No | All | V$TRANSACTION.START_TIME |
Tran Start (TRANS_START) | Start time | -- | string(20) | No | All | V$TRANSACTION.START_TIME |
Used Undo Blocks (USED_UNDO_BLOCKS) | Number of UNDO blocks used | -- | double | No | All | V$TRANSACTION.USED_UBLK |
Used Undo Records (USED_UNDO_RECORDS) | Number of UNDO records used | -- | double | No | All | V$TRANSACTION.USED_UREC |
User (USERNAME) | Oracle user name | -- | string(30) | No | All | V$SESSION.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 (not applicable for an inactive transaction) | -- | string(30) | No | All | V$TRANSACTION.XIDUSN + V$TRANSACTION.XIDSLOT + V$TRANSACTION.XIDSQN |