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` `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`