Locks
These views provide information about the current status of locks in the database:
- DBA_BLOCKERS
Lists all sessions holding locks for whose release others are waiting.
- DBA_DDL_LOCKS
Lists all existing DDL locks.
- DBA_DML_LOCKS
Lists all existing DML locks.
- DBA_KGLLOCK
Lists all KGL (library cache) locks in the database.
- DBA_LOCK_INTERNAL
Contains internal information for each lock defined in DBA_LOCKS.
- DBA_LOCKS
Lists all locks held or requested in the database.
- DBA_WAITERS
Lists all sessions that are waiting on a lock held by another session.
- DBMS_LOCK_ALLOCATED
Shows which locks the current user has allocated.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.