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.

Reports/RM Oracle/Troubleshooting/Real-Time/

Transaction (PD_PDTR)

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(5.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

Report name	Description
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 Cursors	Displays the cursors that are opened by a session. To display this report, choose the SID field.