Longest Transactions - Top 10 Sessions(8.0)
- Organization of this page
Overview
The Longest Transactions - Top 10 Sessions(8.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 - Agent for Oracle does not display this report if the Oracle Database does not have enough performance data to display the report.
Storage location
Reports/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(8.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(4.0) 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(8.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(4.0) |
Displays the cursors that are opened by a session. To display this report, choose the SID field. |