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(128)   Owner of the lock
NAME VARCHAR2(1000)   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 AI Database Concepts for more information about DDL locks