Static Data Dictionary Views, 138 of 452

DBA_DDL_LOCKS

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

Column	Datatype	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`
`MODE_HELD`	`VARCHAR2(9)`	Lock mode: `NONE`, `NULL`, `SHARE`, `EXCLUSIVE`
`MODE_REQUESTED`	`VARCHAR2(9)`	Lock request type: `NONE`, `NULL`, `SHARE`, `EXCLUSIVE`