Manage sessions in the Session Browser.
To open the Session Browser click Tools | Session Browser.
Icon | Tool Tip | Shortcut | Description |
---|---|---|---|
New Session | As per Session | New Session, open the Oracle Logon Dialog | ||
Current Session | Show the current session. Use to switch to a different session. | ||
Include NULL and SYSTEM OS User | Show / Hide NULL and System OS users. | ||
Refresh | F5 | Refresh the Session Browser. | |
Auto Refresh Every… | Refresh the Session Browser automatically. Select Auto-Refresh every and enter the refresh interval in seconds. |
The current session is displayed in pink.
Action | Description | ||
---|---|---|---|
Select / Highlight a session |
The tabbed pages show details of the selected session. For more information, see Session Information. | ||
Sort / Group Sessions |
| ||
Show / Hide Columns |
Right click on the grid and select Visible Columns. All columns are listed. Only selected columns are visible on the grid.
| ||
Filter Sessions |
When a filter is applied, only sessions that meet the criteria are displayed.
To apply custom filters
| ||
Kill Sessions |
Right-click the session and select Kill Sessions.
|
Select a session on the Sessions Grid. Details for the selected session are displayed in the tabbed pages.
Tab |
Description | ||
---|---|---|---|
Session |
Further session information for the selected session. | ||
Process |
Process information for the selected session. | ||
IO |
IO information for the selected session. | ||
Waits |
Waits information for the selected session.
| ||
Current SQL |
The current SQL statement and explain plan for the select session. | ||
Access |
Objects in the database currently locked by the selected session. | ||
RBS Usage |
Transaction information for online rollback segments for the selected session. | ||
Parallel Session |
Parent and slave sessions belonging to a parallel session. | ||
Locks |
User and system locks. Locks are displayed in groups; Blocking, Blocked By, System, and All Locks. | ||
Long Ops |
Operations that run for longer than six seconds in absolute time, including some backup and recovery functions, statistics gathering, and query execution. | ||
Open Cursors |
Cursors that the selected session has opened and parsed. |
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center