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 nameDescription
SIDSession ID
Sort Overflow %Percentage of sort operations using temporary segments. To display the Session Detail(5.0) report, choose this field.
UserOracle user name

Drilldown reports (field level)

Report nameDescription
Session Detail(5.0)Displays detailed information about a session. To display this report, choose the Sort Overflow % field.