DBA_DML_LOCKS

4.216 DBA_DML_LOCKS

DBA_DML_LOCKS lists all DML locks held in the database and all outstanding requests for a DML lock.

Column	Datatype	NULL	Description
`SESSION_ID`	`NUMBER`		Session holding or acquiring the lock
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the lock
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the lock
`MODE_HELD`	`VARCHAR2(13)`		The type of lock held. The values are: `ROWS_S` (`SS`): row share lock `ROW-X` (`SX`): row exclusive lock `SHARE` (`S`): share lock `S/ROW-X` (`SSX`): exclusive lock `NONE`: lock requested but not yet obtained
`MODE_REQUESTED`	`VARCHAR2(13)`		Lock request type. The values are: `ROWS_S` (`SS`): row share lock `ROW-X` (`SX`): row exclusive lock `SHARE` (`S`): share lock `S/ROW-X` (`SSX`): exclusive lock `NONE`: Lock identifier obtained; lock not held or requested
`LAST_CONVERT`	`NUMBER`		Time since current mode was granted
`BLOCKING_OTHERS`	`VARCHAR2(40)`		Blocking others