8.36 V$LIBRARYCACHE
V$LIBRARYCACHE
contains statistics about library cache performance and activity.
Column | Datatype | Description |
---|---|---|
|
|
Library cache namespace |
|
|
Number of times a lock was requested for objects of this namespace |
|
|
Number of times an object's handle was found in memory |
|
|
Ratio of |
|
|
Number of times a PIN was requested for objects of this namespace |
|
|
Number of times all of the metadata pieces of the library object were found in memory |
|
|
Ratio of |
|
|
Any |
|
|
Total number of times objects in this namespace were marked invalid because a dependent object was modified |
|
|
Number of |
|
|
Number of PIN requests lock instance locks |
|
|
Number of release requests PIN instance locks |
|
|
Number of |
|
|
Number of invalidation pings received from other instances |
|
|
The ID of the container to which the data pertains. Possible values include:
|