Locked Objects(5.0)

Overview

The Locked Objects(5.0) report displays real-time information about the objects that are locked by transactions.

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

Transaction Lock (PD_PDTL)

Fields

Field nameDescription
Locked ModeLock mode held. The valid values are as follows:
  • 1 (null)
  • 2 (row share)
  • 3 (row exclusive)
  • 4 (share)
  • 5 (share row exclusive)
  • 6 (exclusive)
Object NameObject name
Object TypeObject type
OwnerObject owner
SIDSession ID. 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 SID field.