Session Detail(8.0)
- Organization of this page
Overview
The Session Detail(8.0) report displays in real-time detailed information about a session. This is a drilldown report.
Storage location
Reports/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(4.0) report, choose this field. |
|
Locks Held |
Number of locks held during data collection |
|
Open Cursors |
Number of open cursors. To display the Open Cursors(4.0) 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(4.0) 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(4.0) |
Displays detailed information about the open cursors in the session. To display this report, choose the Open Cursors field. |
|
Session Statistics Detail(4.0) |
Displays detailed statistical information about a session. To display this report, choose the SID field. |
|
SQL Text(4.0) |
Displays the performance data in the SQL Text and Explain Plan fields. To display this report, choose the Command field. |