Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
|
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 |
|
| Sessions Tab - Session Details - This provides detailed information on the currently selected session |
|
| 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) |
|
| 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. |
|
|
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. |
|
|
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 |
|
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|