Session Detail(5.0)

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

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

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.