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