Longest Transactions - Top 10 Sessions(5.0)

Overview

The Longest Transactions - Top 10 Sessions(5.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 nameDescription
Cache Hit %Percentage of logical I/O operations to physical I/O operations.
LocksNumber of locks being held by the transaction. To display the Blocking Locks(5.0) report, choose this field.
Logical I/OLogical I/O operations
Physical I/OPhysical I/O operations
SIDSession ID. To display the Open Cursors report, choose this field.
Tran SecsNumber of seconds since the transaction started
UserOracle user name

Drilldown reports (field level)

Report nameDescription
Blocking Locks(5.0)Displays a session that includes a lock that places another session in wait status. To display this report, choose the Locks field.
Open CursorsDisplays the cursors that are opened by a session. To display this report, choose the SID field.