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(30)	NOT NULL	Owner of the lock
NAME	VARCHAR2(30)	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		The last convert
BLOCKING_OTHERS	VARCHAR2(40)		Blocking others

Oracle data dictionary views

Oracle dynamic performance views