Data Dictionary View
Columns ___________________________ SESSION_ID OWNER NAME MODE_HELD MODE_REQUESTED LAST_CONVERT BLOCKING_OTHERS
Related:
DBA_DDL_LOCKS DBA_LOCK