Locked Objects(5.0)

Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference

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 name	Description
Locked Mode	Lock 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 Name	Object name
Object Type	Object type
Owner	Object owner
SID	Session ID. 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 SID field.