Capture output from the Oracle server and display it in the Output Window.
Tips For Use
Toggle on/off |
|
Output Window |
|
Oracle Sessions |
|
Capture output from the Oracle server and display it in the Output Window.
Toggle on/off |
|
Output Window |
|
Oracle Sessions |
|
Installing server side objects.
The wizard requires connection as a DBA user so that the SQLNAV user can be created, as well as a number of roles. The wizard permits you to specify a password of your choice for this user. Note that the option "Base SQLNAV Repository" must be selected on at least one occasion to allow the other support features to be installed. All objects installed by the wizard are installed into the SQLNAV schema.
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. |
Preview the source code of text objects (stored programs, triggers and views), or a package’s individual entry points.
Select the object
Module | How to select the object |
---|---|
In the Code Editor | Press CTRL and click on the object name |
In DB Navigator | Click on the object |
In the Find objects Dialog results | Click on the object |
In Database Source Code Search results | Click on the object |
In the Project Manager | Click on the object |
In DB Explorer | Click on the object |
Click View | Source Preview.
|
TIP:
|
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 使用条款 隐私 Cookie Preference Center