Blocking Locks(5.0)

Overview

The Blocking Locks(5.0) report displays real-time information about a session that includes a lock that places another session in wait status.

If you cannot display this report, create Oracle's static dictionary view DBA_WAITERS. To create the static dictionary view DBA_WAITERS, you must execute the CATBLOCK.SQL script provided by Oracle.

PFM - RM for Oracle does not display this report if the Oracle Database does not have enough performance data to display the report.

Storage location

Reports/RM Oracle/Troubleshooting/Real-Time/

Record

Lock Waiters (PD_PDLW)

Fields

Field nameDescription
Holding SessionSession ID that has the lock. To display the Locked Objects(5.0) report, choose this field.
Holding UserName of the user that has the lock
Mode HeldLock mode held during data collection
Mode RequestedLock mode requested during data collection
Waiting SessionSession ID waiting for lock release. To display the Session Detail(5.0) report, choose this field.
Waiting UserName of the user waiting for the lock to be released

Drilldown reports (report level)

Report nameDescription
Longest Transactions - Top 10 Sessions(5.0)Displays the top 10 transactions in terms of the length of a transaction that places another session in wait status.

Drilldown reports (field level)

Report nameDescription
Locked Objects(5.0)Displays the objects that are locked by the session. To display this report, choose the Holding Session field.
Session Detail(5.0)Displays detailed information about the session. To display this report, choose the Waiting Session field.