DBA_WAITERS
Columns ___________________________ WAITING_SESSION -- HOLDING_SESSION -- LOCK_TYPE -- MODE_HELD -- MODE_REQUESTED -- LOCK_ID1 -- LOCK_ID2 --
Related:
Simon Sheppard SS64.com