Session Detail(5.0)
Overview
The Session Detail(5.0) report displays in real-time detailed information about a session. This is a drilldown report.
Storage location
Reports/RM Oracle/Troubleshooting/Real-Time/Drilldown Only/
Record
Session Detail (PD_PDS)
Fields
Field name | Description |
---|---|
Addrhash | Character string that identifies the SQL statement being executed |
Blocking Locks | Number of locks that are blocking other locks |
Command | Command being executed. To display the SQL Text report, choose this field. |
Locks Held | Number of locks held during data collection |
Open Cursors | Number of open cursors. To display the Open Cursors report, choose this field. |
Program | Name of the program being executed |
Session Events | Number of events the session is waiting for |
Session Waits | Number of resources and events the session is waiting for |
Sessions Blocked | Number of sessions that have been placed in wait status by this session |
SID | Session ID. To display the Session Statistics Detail report, choose this field. |
Table Accesses | Number of table accesses |
Transactions | Number of active transactions |
User | Oracle user name |
Drilldown reports (field level)
Report name | Description |
---|---|
Open Cursors | Displays detailed information about the open cursors in the session. To display this report, choose the Open Cursors field. |
Session Statistics Detail | Displays detailed statistical information about a session. To display this report, choose the SID field. |
SQL Text | Displays the performance data in the SQL Text and Explain Plan fields. To display this report, choose the Command field. |