Transaction (PD_PDTR)
- Organization of this page
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 |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
-
PD_PDTR_SID
-
PD_PDTR_ADDRESS
Lifetime
From the start to the end of a transaction
Record size
-
Fixed part: 935 bytes
-
Variable part: 240 bytes
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.CR_GET) - V$TRANSACTION.PHY_IO) / (V$TRANSACTION.LOG_IO + V$TRANSACTION.CR_GET)) * 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 |