Dba_lock
Oracle Lock Conflicts with dba_lock and SQL*Plus Format
Sep 6, 2024 / · 3 min read · Database SQL Performance Troubleshooting Oracle Database Administration Performance Tuning dba_lock ·Oracle Database: Understanding Lock Conflicts with dba_lock and Column Formatting Purpose DBA_LOCK lists all locks or latches held in the database, and all outstanding requests for a lock or latch. This query reads that view to show which sessions hold or want each lock, the lock modes involved, and whether a lock is …
Read More