![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.