Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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