Transaction Interval (PI_PITR)
- Organization of this page
Function
The Transaction Interval (PI_PITR) record stores performance data, taken at specific intervals, about transactions. PFM - Agent for Oracle creates one record for each transaction. This is a multi-instance record.
When Log is set to Yes, if you collect history over a long period of time, because of the short lifetime, it is not summarized in units of years or months. All instances are retained, resulting in a bloated store database. In addition, when the collected history is summarized, more memory is used than necessary. The memory shortage might cause monitoring to stop. If you want to collect history over a long period of time, use the Transaction (PD_PDTR) record for monitoring.
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
-
PI_PITR_SID
-
PI_PITR_ADDRESS
Lifetime
From the start to the end of a transaction
Record size
-
Fixed part: 678 bytes
-
Variable part: 348 bytes
Fields
PFM - View name (PFM - Manager name) |
Description |
Summary |
Format |
Delta |
Supported version |
Data source |
---|---|---|---|---|---|---|
Address (ADDRESS) |
Address of the transaction status object#1 |
COPY |
string(16) |
No |
All |
V$TRANSACTION.ADDR |
Cache Hit % (CACHE_HIT_PERCENTAGE) |
Cache hit rate#2 |
AVG |
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#2 |
AVG |
double |
No |
All |
(V$TRANSACTION.CR_CHANGE / V$TRANSACTION.CR_GET) * 100 |
Consistent Changes (CONSISTENT_CHANGES) |
Number of consistent changes#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.CR_CHANGE |
Consistent Gets (CONSISTENT_GETS) |
Number of consistent acquisitions#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.CR_GET |
Locks (LOCKS) |
Number of locks caused by the transaction#2 |
AVG |
double |
Yes |
All |
COUNT(V$LOCKED_OBJECT) |
Logical I/O (LOGICAL_IO) |
Logical I/O#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.LOG_IO |
No Undo (NO_UNDO) |
Identifier of a non-UNDO transaction (if this is a non-UNDO transaction, the value of this field is Yes; otherwise, the value is No)#1 |
COPY |
string(3) |
No |
All |
V$TRANSACTION.NOUNDO |
Physical I/O (PHYSICAL_IO) |
Physical I/O#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.PHY_IO |
Previous XID (PREVIOUS_XID) |
Parent transaction ID#1 |
COPY |
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#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Record Type (INPUT_RECORD_TYPE) |
Record name (always PITR)#1 |
COPY |
string(4) |
No |
All |
Agent Collector |
Recursive (RECURSIVE) |
Identifier of a recursive transaction (if this is a recursive transaction, the value of this field is Yes; otherwise, the value is No)#1 |
COPY |
string(3) |
No |
All |
V$TRANSACTION.RECURSIVE |
SID (SID) |
Session ID#1 |
COPY |
ulong |
No |
All |
V$SESSION.SID where V$TRANSACTION.SES_ADDR = V$SESSION.ADDR |
Space (SPACE) |
Identifier of a space transaction (if this is a space transaction, the value of this field is Yes; otherwise, the value is No)#1 |
COPY |
string(3) |
No |
All |
V$TRANSACTION.SPACE |
Start Time (START_TIME) |
Collection start time for the performance data stored in the record#1 |
COPY |
time_t |
No |
All |
Agent Collector |
Status (STATUS) |
Transaction status#1 |
COPY |
string(16) |
No |
All |
V$TRANSACTION.STATUS |
Tran Secs (TRANS_SECS) |
Number of seconds since the start time#1 |
COPY |
ulong |
No |
All |
V$TRANSACTION.START_TIME |
Tran Start (TRANS_START) |
Start time#1 |
COPY |
string(20) |
No |
All |
V$TRANSACTION.START_TIME |
Used Undo Blocks (USED_UNDO_BLOCKS) |
Number of UNDO blocks used#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.USED_UBLK |
Used Undo Records (USED_UNDO_RECORDS) |
Number of UNDO records used#2 |
AVG |
double |
Yes |
All |
V$TRANSACTION.USED_UREC |
User (USERNAME) |
Oracle user name#1 |
COPY |
string(30) |
No |
All |
V$SESSION.USERNAME |
XID (XID) |
UNDO segment number, slot number, and sequence number (this field is not applicable to an inactive transaction)#1 |
COPY |
string(30) |
No |
All |
V$TRANSACTION.XIDUSN + V$TRANSACTION.XIDSLOT + V$TRANSACTION.XIDSQN |