Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - User Guide

Quick Overview Working With SQL Navigator Navigation Oracle Logon Code Editor Visual Object Editors Team Coding and Version Control Systems Modules, Windows And Dialogs
Analyze Tool Auto Describe Tool Benchmark Factory Bookmarks Dialog Capture Web Output Change Logon Password Dialog Code Analysis Code Assistant Code Road Map Code Templates Code Test Database Source Code Search Dialog DB Navigator Describe Difference Viewer Edit Data ER Diagram Explain Plan Tool Export Table Find and Replace Dialog Find objects Dialog Find Recycle Bin Objects Dialog Formatting Options HTML Viewer Import HTML as PL/SQL Import Table Java Manager Job Scheduler Locate In Tree Output Window PL/SQL Profiler Profile Manager Project Manager Publish Java to PL/SQL Quick Browse Rename Object Search Knowledge Xpert Select DB Object Dialog Server Output Server Side Installation Wizard Session Browser Source Preview SQL Modeler SQL Optimizer Task Manager Web Support Configuration Dialog Wrap Code
View | Preferences About Us

Server Output

Modules, Windows And Dialogs > Server Output

Capture output from the Oracle server and display it in the Output Window.


Tips For Use

Toggle on/off

  • Toggle on/off capturing server output from the Session Menu.
  • Click Session | Server Output to toggle On/Off Server output.

Output Window

  • When toggled ON the Output Window opens if it is not already open.
  • Closing the Output Window does not stop the capturing of Server Output.
  • The Output Window reopens automatically if you execute a stored program in a session capturing server output.
  • The default size of the run time buffer is 32k bytes.

Oracle Sessions

  • Output is captured for the current Oracle session.
  • Server Output is captured individually for each session. Capturing it in one session does not automatically capture it in other concurrent sessions.

Server Side Installation Wizard

Modules, Windows And Dialogs > Server Side Installation Wizard

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.

Session Browser

Modules, Windows And Dialogs > Session Browser

Manage sessions in the Session Browser.

To open the Session Browser click Tools | Session Browser.

Session Browser Toolbar

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.

Sessions Grid

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

  • Click the column heading you would like to sort by.
  • Drag the column you would like to group the sessions by to the gray area above the grid.

Show / Hide Columns

Right click on the grid and select Visible Columns. All columns are listed. Only selected columns are visible on the grid.

TIP: You can rearrange the columns. Drag and drop the column header into the location you want.

Filter Sessions

When a filter is applied, only sessions that meet the criteria are displayed.

  1. Click the arrow alongside the column heading you want to apply the filter to.
  2. Select the value you want to filter by.
  3. Apply additional filters if required.

To apply custom filters

  1. Click the arrow alongside the column heading you want to apply the filter to and select (Custom...).
  2. Create a conditional expression from the menu options provided.
    • Values are case sensitive.
    • Use And / Or to related multiple conditions.


  • The filtered columns are given a blue arrow. Click the blue arrow and select (All) to remove all filters applied to the column.
  • The filter expression is displayed below the Sessions grid. Click X to remove all filters.

Kill Sessions

Right-click the session and select Kill Sessions.


  • When you kill a top level node you kill all sessions below it.
  • You must have appropriate permissions (ALTER SYSTEM) to kill sessions.
  • You cannot kill the current session (displayed in pink).
  • The following query is used to kill sessions: ALTER SYSTEM KILL SESSION <SID, SERIAL#> IMMEDIATE

Session Information

Select a session on the Sessions Grid. Details for the selected session are displayed in the tabbed pages.




Further session information for the selected session.


Process information for the selected session.


IO information for the selected session.


Waits information for the selected session.

Note: WAIT_TIME = -2 on platforms that do not support a fast timing mechanism. If you using one of these platforms and you want this column to reflect true wait times, you must set the TIMED_STATISTICS parameter to TRUE. Doing this has a small negative effect on system performance.

Current SQL

The current SQL statement and explain plan for the select session.


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.


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.


Source Preview

Modules, Windows And Dialogs > Source Preview

Preview the source code of text objects (stored programs, triggers and views), or a package’s individual entry points.

  1. 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
  2. Click View | Source Preview.


  • While the Source Preview window is open, you can select objects in any of the windows named above, and the object’s source code will automatically appear in the Source Preview window.
  • Use a bookmark to conveniently mark various locations in the source code and quickly move about in the text without searching through the code and without losing your current editing location. You can set up to ten bookmarks. See Edit Menu.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating