Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Oracle Description, User's Guide and Reference


Locked Objects(9.1)

Organization of this page

Overview

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

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

Note:

The drilldown report of the locked objects that are not performed transactions cannot be displayed correctly.

Storage location

Reports/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(9.1) report, choose this field.

User

Oracle user name

Drilldown reports (field level)

Report name

Description

Session Detail(9.1)

Displays detailed information about a session. To display this report, choose the SID field.