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 nameDescription
AddrhashCharacter string that identifies the SQL statement being executed
Blocking LocksNumber of locks that are blocking other locks
CommandCommand being executed. To display the SQL Text report, choose this field.
Locks HeldNumber of locks held during data collection
Open CursorsNumber of open cursors. To display the Open Cursors report, choose this field.
ProgramName of the program being executed
Session EventsNumber of events the session is waiting for
Session WaitsNumber of resources and events the session is waiting for
Sessions BlockedNumber of sessions that have been placed in wait status by this session
SIDSession ID. To display the Session Statistics Detail report, choose this field.
Table AccessesNumber of table accesses
TransactionsNumber of active transactions
UserOracle user name

Drilldown reports (field level)

Report nameDescription
Open CursorsDisplays detailed information about the open cursors in the session. To display this report, choose the Open Cursors field.
Session Statistics DetailDisplays detailed statistical information about a session. To display this report, choose the SID field.
SQL TextDisplays the performance data in the SQL Text and Explain Plan fields. To display this report, choose the Command field.