Hitachi

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


Longest Transactions - Top 10 Sessions(7.0)

Organization of this page

Overview

The Longest Transactions - Top 10 Sessions(7.0) report displays in real-time the top 10 transactions in terms of the length of a transaction that placed another session in wait status.

PFM - RM for Oracle does not display this report if the Oracle Database does not have enough performance data to display the report.

Storage location

Reports/RM Oracle/Troubleshooting/Real-Time/

Record

Transaction (PD_PDTR)

Fields

Field name

Description

Cache Hit %

Percentage of logical I/O operations to physical I/O operations.

Locks

Number of locks being held by the transaction. To display the Blocking Locks(7.0) report, choose this field.

Logical I/O

Logical I/O operations

Physical I/O

Physical I/O operations

SID

Session ID. To display the Open Cursors report, choose this field.

Tran Secs

Number of seconds since the transaction started

User

Oracle user name

Drilldown reports (field level)

Report name

Description

Blocking Locks(7.0)

Displays a session that includes a lock that places another session in wait status. To display this report, choose the Locks field.

Open Cursors

Displays the cursors that are opened by a session. To display this report, choose the SID field.