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

ItemDefault valueChangeable
Collection Interval600Y
Collection Offset145Y
LogNoY
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)
DescriptionSummaryFormatDeltaSupported versionData source
Address
(ADDRESS)
Address of the transaction status object--string(16)NoAllV$TRANSACTION.ADDR
Cache Hit %
(CACHE_HIT_PERCENTAGE)
Cache hit rate--doubleNoAll((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--doubleNoAll(V$TRANSACTION.CR_CHANGE / V$TRANSACTION.CR_GET) * 100
Consistent Changes
(CONSISTENT_CHANGES)
Number of consistent changes--doubleNoAllV$TRANSACTION.CR_CHANGE
Consistent Gets
(CONSISTENT_GETS)
Number of consistent acquisitions--doubleNoAllV$TRANSACTION.CR_GET
Locks
(LOCKS)
Number of transaction locks--doubleNoAllCOUNT(V$LOCKED_OBJECT)
Logical I/O
(LOGICAL_IO)
Logical I/O--doubleNoAllV$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)NoAllV$TRANSACTION.NOUNDO
Physical I/O
(PHYSICAL_IO)
Physical I/O--doubleNoAllV$TRANSACTION.PHY_IO
Previous XID
(PREVIOUS_XID)
Parent transaction ID--string(30)NoAllV$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_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PDTR)--string(4)NoAllRemote 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)NoAllV$TRANSACTION.RECURSIVE
SID
(SID)
Session ID--ulongNoAllV$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)NoAllV$TRANSACTION.SPACE
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Status
(STATUS)
Transaction status--string(16)NoAllV$TRANSACTION.STATUS
Tran Secs
(TRANS_SECS)
Number of seconds since the start time--ulongNoAllV$TRANSACTION.START_TIME
Tran Start
(TRANS_START)
Start time--string(20)NoAllV$TRANSACTION.START_TIME
Used Undo Blocks
(USED_UNDO_BLOCKS)
Number of UNDO blocks used--doubleNoAllV$TRANSACTION.USED_UBLK
Used Undo Records
(USED_UNDO_RECORDS)
Number of UNDO records used--doubleNoAllV$TRANSACTION.USED_UREC
User
(USERNAME)
Oracle user name--string(30)NoAllV$SESSION.USERNAME
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
XID
(XID)
UNDO segment number, slot number, and sequence number (not applicable for an inactive transaction)--string(30)NoAllV$TRANSACTION.XIDUSN + V$TRANSACTION.XIDSLOT + V$TRANSACTION.XIDSQN