How to Find Locks on Library Cache Objects


We can see the locks on Library cache objects in V$ACCESS (GV$ACCESS on RAC systems).

The dependency on objects is managed by library locks. For example, when a column in a table is dropped, objects (such as images) that need this table must be invalid.

With these locks;

  • A client can prevent other clients from accessing the same object
  • The client can provide dependency for a long time.

The sample query is as follows:

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 *