DBA_DDL_LOCKS

DBA_DDL_LOCKS lists all DDL locks held in the database and all outstanding requests for a DDL lock.

Column Datatype NULL Description

SESSION_ID

NUMBER

  

Session identifier

OWNER

VARCHAR2(30)

  

Owner of the lock

NAME

VARCHAR2(30)

  

Name of the lock

TYPE

VARCHAR2(40)

  

Lock type:

  • Cursor

  • Table/Procedure/Type

  • Body

  • Trigger

  • Index

  • Cluster

  • Java Source

  • Java Resource

  • Java Data

MODE_HELD

VARCHAR2(9)

  

Lock mode:

  • None

  • Null

  • Share

  • Exclusive

MODE_REQUESTED

VARCHAR2(9)

  

Lock request type:

  • None

  • Null

  • Share

  • Exclusive

See Also:

Oracle Database Concepts for more information about DDL locks