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 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.
Contents
Opening the Top Sessions Dialog Box
- 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. |
ORACLE ONLY: Displays waits. | |
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. |