This event manages library cache concurrency. Pinning an object causes the heaps to be loaded into memory. If a client wants to modify or examine the object, the client must acquire a pin after the lock.
Wait Time: 3 seconds (1 second for PMON)
Parameter | Description |
---|---|
handle address |
Address of the object being loaded |
pin address |
Address of the load lock being used. This is not the same thing as a latch or an enqueue, it is basically a State Object. |
mode |
Indicates which data pieces of the object that 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