Library cache lock
What is "Library cache lock" ?
- One client can prevent other clients from accessing the same object.
- The client can maintain a dependency for a long time (for example, so that no other client can change the object).
Library cache lock will be obtained on database objects referenced during parsing or compiling of SQL or PL/SQL statements (table, view, procedure, function, package, package body, trigger, index, cluster, synonym). The lock will be released at the end of the parse or compilation.
Cursors (SQL and PL/SQL areas), pipes and any other transient objects do not use this lock.
Library cache lock is not deadlock sensitive and the operation is synchronous.
- handle address:
Address of the object being loaded.
- lock address:
Address of the load lock being used. This is not the same thing as a latch or an enqueue, it is a State Object.
Indicates the data pieces of the object which need to be loaded.
The name of the object namespace as it is displayed in V$DB_OBJECT_CACHE view