5.146 DBA_LOCK_INTERNAL

DBA_LOCK_INTERNAL displays a row for each lock or latch that is being held, and one row for each outstanding request for a lock or latch.

Column Datatype NULL Description

SESSION_ID

NUMBER

Session holding or acquiring the lock

LOCK_TYPE

VARCHAR2(56)

Lock type

See Also: For a listing of lock types, see Oracle Enqueue Names

MODE HELD

VARCHAR2(40)

Lock mode

MODE REQUESTED

VARCHAR2(40)

Lock mode requested

LOCK_ID1

VARCHAR2(1130)

Type-specific lock identifier, part 1

LOCK_ID2

VARCHAR2(40)

Type-specific lock identifier, part 2

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data