Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)
Part Number E10820-02
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us
Go to previous page
Previous		 Go to next page
Next
View PDF

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

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Index
Index		 Go to Master Index
Master Index		 Go to Feedback page
Contact Us