How To Find Locked Database Objects

 

There are many tables and views in Oracle database that we can get information about with locked objects. You can access a lot of information from the following views.

  • DBA_BLOCKERS
  • DBA_DDL_LOCKS
  • DBA_DML_LOCKS
  • DBA_LOCK_INTERNAL
  • DBA_LOCKS
  • DBA_WAITERS

Find locks in a table:

You can detect locks in a table with the following query.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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