This event controls the concurrency between clients of the library cache. It acquires a lock on the object handle so that either:
One client can prevent other clients from accessing the same object
The client can maintain a dependency for a long time (for example, no other client can change the object)
This lock is also obtained to locate an object in the library cache.
Wait Time: 3 seconds (1 second for PMON)
Parameter | Description |
---|---|
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. |
mode |
Indicates the data pieces of the object which must be loaded |
namespace |
See "namespace" |
See Also:
Oracle Database Performance Tuning Guide for more information about this wait event
Oracle Database Performance Tuning Guide for more information about potential causes of this wait event