How to Find Locks on Library Cache Objects

dbtut

6 years ago

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:

SQL> select * from gv$access WHERE OBJECT='your_object_name';

1	SQL> select * from gv$access WHERE OBJECT='your_object_name';