DBPedias

All your database knowledge are belong to you

Oracle

Wait Events - library cache pin

library cache pin

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 needs to be loaded

namespace

namespace