DBA_DDL_LOCKS
Columns ___________________________ SESSION_ID -- OWNER -- NAME -- TYPE -- MODE_HELD -- MODE_REQUESTED --
Related:
Simon Sheppard SS64.com