DBA_HIST_LIBRARYCACHE
displays historical statistics about library cache performance and activity. This view contains snapshots of V$LIBRARYCACHE
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
Library cache namespace |
|
|
Number of times a lock was requested for objects of the namespace |
|
|
|
Number of times an object's handle was found in memory |
|
|
|
Number of times a PIN was requested for objects of the namespace |
|
|
|
Number of times all of the metadata pieces of the library object were found in memory |
|
|
|
Any PIN of an object that is not the first PIN performed since the object handle was created, and which requires loading the object from disk |
|
|
|
Total number of times objects in the namespace were marked invalid because a dependent object was modified |
|
|
|
Number of GET requests lock instance locks |
|
|
|
Number of PIN requests lock instance locks |
|
|
|
Number of release requests PIN instance locks |
|
|
|
Number of GET requests for invalidation instance locks |
|
|
|
Number of invalidation pings received from other instances |
|
|
|
The database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: