Top Sessions (ORCL)

From DBArtisan
Jump to: navigation, search

Go Up to Data, Schema, and Miscellaneous Utilities

Being able to identify the top resource users in an Oracle system is a valuable tuning asset. The Top Sessions Options Dialog Boxlets you quickly pinpoint the heaviest users of I/O and memory usage. The Top Sessions utility quickly finds and ranks user sessions based on their resource usage.

Opening the Top Sessions Dialog Box

  1. On the Utilities menu, select Top Sessions.
DBArtisan opens the Top Sessions dialog.

The table below describes the options and functionality on the Top Sessions dialog.

Tip: Click the Options button to open the Top Sessions Options Dialog Box.

Top Sessions Options Dialog Box

The table below describes the options and functionality on the Top Sessions Options dialog:


Option Description

Exclude Sys and System

Select to force the query used to display top session data to be changed.

Exclude Background Process

Select to force the query used to display top session data to be changed.

Limit Top Session Display to

Lets you specify the number of sessions to display. These options will force the query used to display top session data to be changed.

No Limit

Sort Top Sessions By

Lets you custom soft the display

User Session Information Dialog Box

The table below describes the options and functionality on the User Session Information dialog:

Option Description

User

Lets you select a user.

OS User Name

Displays the operating system user name.

Session ID

Lets you select the application.

Machine Name

Displays the name of the datasource.

Status

Displays the session status.

Terminal Name

Displays the terminal name.

Command

Displays the command.

Program

Displays the program used.

Client Platform

IBM DB2 FOR WINDOW/UNIX ONLY: Lets you select the client platform.

Client Protocol

IBM DB2 FOR WINDOW/UNIX ONLY: Lets you select the client protocol.

Session Parameters

IBM DB2 FOR WINDOW/UNIX ONLY: Lets you select the session parameters.

User Session Information Dialog Box - Statistical Details tab

ORACLE ONLY: Displays statistical details.

User Session Information Dialog Box - Waits Tab

ORACLE ONLY: Displays waits.

User Session Information Dialog Box - Current SQL Tab

ORACLE ONLY: Displays the current SQL.

User Session Information Dialog Box - Statistical Details tab

The table below describes the options and functionality on the Statistical Details tab of the User Session Information dialog:

Option Description

Statistical Details grid

Displays the session parameters and value (if any).

User Session Information Dialog Box - Waits Tab

The table below describes the options and functionality on the Statistical Details tab of the User Session Information dialog:

Option Description

Historical Waits

If selected, displays historical waits in the waits grid.

Current Waits

If selected, displays current waits in the waits grid.

Include Idle Waits

If selected, displays idle waits in the waits grid.

Waits grid

Displays the wait information, including Session ID, Event, Seconds in Wait, Wait Time, State, and other information.

User Session Information Dialog Box - Current SQL Tab

The table below describes the options and functionality on the Statistical Details tab of the User Session Information dialog:

Option Description

SQL box

Displays current SQL.