Data Dictionary View
Columns ___________________________ SESSION_ID LOCK_TYPE MODE_HELD MODE_REQUESTED LOCK_ID1 LOCK_ID2 LAST_CONVERT BLOCKING_OTHERS
Related:
DBA_DDL_LOCKS DBA_DML_LOCKS DBA_LOCK_INTERNAL DBA_WAITERS DBA_BLOCKERS DBA_KGLLOCK