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 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 |
Drilldown reports (field level)
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. |