Sessions Page
Shows user sessions where sorting may be a problem.
To open the Sessions page
-
Select the Spotlight on Oracle RAC connection in the Spotlight Browser.
-
Click SQL & Application Workload | Sort Activity Page | Sessions.
Top Sessions by Sort Activity Grid
Problem sessions may have the largest values for:
- Temp File Reads: This column shows which sorts have the highest number of multi-pass operations.
- Sorts Disk and Sorts Memory: This column indicates where sorts are performed. Disk sorts are the most wasteful.
- Multipass Sorts: The most wasteful type of disk sorts.
When you identify a problem session you may decide to kill it:
- Double click on the session to open the Top Sessions Page.
- On the Top Sessions page, right-click the problem session and select Kill/Disconnect Session. Top Sessions Page
| Column | Description |
|---|---|
| Instance name | The instance in the Oracle RAC cluster where the session is connected. |
|
SID |
Session ID of the connected session. |
|
Oracle User |
The user running the session. |
|
Program |
The program running in the session. |
|
Module |
The active module within the program. |
|
Sorts Memory |
The number of sorting operations performed ONLY in memory. These are the most efficient sorts, as they require no I/O access to disk. |
|
Sorts Disk |
The number of sorting operations that require at least one I/O operation to disk. These may be one-pass OR multi-pass sorts. |
|
Rows Sorted |
The number of rows sorted while executing SQL statements during the session. |
|
Temp File Reads |
The number of times that data has been read from disk during the session. |
|
Temp File Writes |
The number of times that data has been written to disk during the session. |
|
Optimal Sorts |
The number of times within the session that sorting has been performed entirely in memory. |
|
Onepass Sorts |
The number of times within the session that sorting has been performed with a single I/O operation to disk. |
|
Multipass Sorts |
The number of times that within the session that sorting has been performed with multiple I/O operation to disk. |
|
Machine |
The machine where the session originated. |
|
OS User |
The O/S user that initiated the session. |
Note: The metrics in the Top Sessions by Sort Activity table are derived from data collected from V$SESSTAT.