Disk Sorts - Top 10 Sessions(5.0)
Overview
The Disk Sorts - Top 10 Sessions(5.0) report displays in real-time the top 10 sessions that frequently perform disk sort operations.
Storage location
Reports/RM 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(5.0) report, choose this field. |
User | Oracle user name |
Drilldown reports (field level)
Report name | Description |
---|---|
Session Detail(5.0) | Displays detailed information about a session. To display this report, choose the Sort Overflow % field. |