Lock Usage - Top 10 Sessions(5.0)

Overview

The Lock Usage - Top 10 Sessions(5.0) report displays in real-time the top 10 sessions in terms of the number of locks being held.

Storage location

Reports/RM Oracle/Troubleshooting/Real-Time/

Record

Session Detail (PD_PDS)

Fields

Field nameDescription
Locks HeldNumber of locks held during data collection. To display the Session Detail(5.0) report, choose this field.
SIDSession ID
UserOracle user name

Drilldown reports (field level)

Report nameDescription
Session Detail(5.0)Display detailed information about a session. To display this report, choose the Locks Held field.