Data Dictionary View
Columns ___________________________ SESSION_ID OWNER NAME TYPE MODE_HELD MODE_REQUESTED
Related:
DBA_DML_LOCKS DBA_LOCK