Disk Sorts - Top 10 Sessions(9.1)
- Organization of this page
Overview
The Disk Sorts - Top 10 Sessions(9.1) report displays in real-time the top 10 sessions that frequently perform disk sort operations.
Storage location
Reports/Oracle/Troubleshooting/Real-Time/
Record
Session Statistics Summary (PD_PDS2)
Fields
|
Field name |
Description |
|---|---|
|
SID |
Session ID |
|
Sort Overflow % |
Percentage of sort operations using temporary segments. To display the Session Detail(9.1) report, choose this field. |
|
User |
Oracle user name |
Drilldown reports (field level)
|
Report name |
Description |
|---|---|
|
Session Detail(9.1) |
Displays detailed information about a session. To display this report, choose the Sort Overflow % field. |