Chat now with support
Chat with Support

SQL Navigator for Oracle 7.4 - Release Notes

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.

Note:

  • 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.

Note:

  • 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.

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.

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.

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.

 

 

Related Topics

Open From: Tools Menu | Session Browser.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating