DBA_LOCK
Columns ___________________________ SESSION_ID -- LOCK_TYPE -- MODE_HELD -- MODE_REQUESTED -- LOCK_ID1 -- LOCK_ID2 -- LAST_CONVERT -- BLOCKING_OTHERS --
Related:
Simon Sheppard SS64.com