Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


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

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#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