Top Sessions (ORCL)

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 Box lets 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.

To open the Top Sessions dialog

• On the Utilities menu, select Top Sessions.

  DBArtisan opens the Top Sessions dialog.

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

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

Top Sessions Options Dialog Box

The following table 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 following table describes the options and functionality on the User Session Information dialog:

Topic	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 Windows/UNIX only. Lets you select the client platform.
Client Protocol	IBM DB2 for Windows/UNIX only. Lets you select the client protocol.
Session Parameters	IBM DB2 for Windows/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 following table 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 following table 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 following table describes the options and functionality on the Statistical Details tab of the User Session Information dialog:

Option	Description
SQL box	Displays current SQL.