Oracle DBA Tools - Session Manager
Provides manageability of database sessions, including user and system locks. Allowing the user to kill/disconnect sessions, start traces and monitor open cursors and user queries with execution plans.
|
Toolbar Operations -
Refresh : Refresh all the tab results from the database
Refresh Seconds: The interval in which to refresh the tabs if "Auto Refresh" is enabled
Auto Refresh: Indicates whether to refresh the tab results automatically every X number
of seconds determined by the "Refresh Seconds"
|
Sessions Tab - Provides a list of sessions currently held by the
Oracle server
Program: Operating System program name
Machine: Operating System machine name
User Name: Oracle username
OS User: Operating System client user name
Server: Server type {DEDICATED, SHARED, PSEUDO, NONE}
SID: Session Identifier
AUDSID: Auditing session ID
SPID: Operating System process identifier
Status: Status of the session {ACTIVE, INACTIVE, KILLED, CACHED, SNIPED}
Terminal: Operating System terminal name
Type: Session type
|
Oracle DBA Tools - Session Manager - Syntax Coloring
 Oracle DBA Tools - Session Manager - Sessions Tab |
Sessions Tab - Session Details - This provides detailed information on the
currently selected session
|
 Oracle DBA Tools - Session Manager - Session Details Tab |
Sessions Tab - Current Statement - This provides the current statement for the currently
selected session. The user may also run a visual explain plan on the SQL statement. (Visual Explain must be
configured in File->Options:Visual Explain)
|
 Oracle DBA Tools - Session Manager - Current Statement Tab
|
Sessions Tab - Open Cursor - This provides a list of open cursors for the currently
selected session. Selecting a cursor will load the SQL for that cursor into the right panel where the
user may run a Visual Explain on it.
|
 Oracle DBA Tools - Session Manager - Open Cursor Tab
|
Session Stats Tab - Provides a list of sessions currently held by the
Oracle server with some statistical information
SID: Session Identifier
AUDSID: Auditing session ID
User Name: Oracle username
OS User: Operating System client user name
Status: Status of the session {ACTIVE, INACTIVE, KILLED, CACHED, SNIPED}
Lock Wait: Address of lock waiting for by this session
Program: Operating System program name
Machine: Operating System machine name
Connect Time: Time of logon
P Program: Program in progress
Physical Reads: Physical reads for this session
Block Gets: Block gets for this session
Consistents Gets: Consistent changes for this session
Block Changes: Block changes for this session
Consistent Changes: Consistent changes for this session
Process: Operating System client process ID
SPID: Operating System process identifier
PID: Oracle process identifier
Serial #: Session serial number. Used to uniquely identify a session's objects.
Guarantees that session-level commands are applied to the correct session objects if
the session ends and another session begins with the same session ID.
|
 Oracle DBA Tools - Session Manager - Session Statistics Tab
|
Locks (User) Tab - Provides a list of locks held by users on the server
Session / Lock: Session ID and the locks that are being held or are blocking the session
Session ID: Session Identifier
AUDID: Auditing session ID
User: Oracle username
Lock Type: The type of lock held by the session
Mode Held: Lock mode in which the session holds the lock
Mode Request: Lock mode in which the process requests the lock
Command: Command in progress (last statement parsed)
Object Type: Type of object
Owner: Owner of the object locked
Object Name: Name of the object blocked
Blocking: Indicates if the session is blocking another
OS User: Operating System client user name
Machine Name: Operating System machine name
|
 Oracle DBA Tools - Session Manager - Lock User Tab
|
Locks (System) Tab - Provides a list of system locks on the server
Lock Type: The type of lock held by the session
Mode Held: Lock mode in which the session holds the lock
Mode Requested: Lock mode in which the process requests the lock
Lock ID1: Lock identifier #1
Lock ID2: Lock identifier #2
|
 Oracle DBA Tools - Session Manager - Lock System Tab
|
