Where to find info about locks

  • DBA_BLOCKERS – Shows non-waiting sessions holding locks being waited-on
  • DBA_DDL_LOCKS – Shows all DDL locks held or being requested
  • DBA_DML_LOCKS  – Shows all DML locks held or being requested
  • DBA_LOCK_INTERNAL – Displays 1 row for every lock or latch held or being requested with the username of who is holding the lock
  • DBA_LOCKS  – Shows all locks or latches held or being requested
  • DBA_WAITERS  – Shows all sessions waiting on, but not holding waited for locks

Leave a Reply

Your email address will not be published. Required fields are marked *