GVD_LIBRARYCACHE - Oracle monitoring: Copy of GV$LIBRARYCACHE
Oracle monitoring: Copy of GV$LIBRARYCACHE information is stored in SAP table GVD_LIBRARYCACHE.
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
It is part of development package STUN in software component BC-CCM-MON-TUN. This development package consists of objects that can be grouped under "SAP Monitoring Tools".
Fields for table GVD_LIBRARYCACHE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | Oracle monitor: snapshot ID | X | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | Oracle monitor: Instance ID | X | ORA_INST_ID | DEC | 12 | |
| NAMESPACE | Oracle Monitoring: The library cache namespace | X | ORA_NAMESPACE | CHAR | 15 | |
| GETS | Oracle monitoring: # a lock was requested for objects | ORA_GETS_LIB | DEC | 12 | ||
| GETHITS | Oracle monitoring: # an object's handle was found in memory | ORA_GETHITS | DEC | 12 | ||
| GETHITRATIO | Oracle monitoring: The ratio of GETHITS to GETS | ORA_GETHITRATIO | DEC | 12 | ||
| PINS | Oracle monitoring: # PIN was requested for objects in namesp | ORA_PINS | DEC | 12 | ||
| PINHITS | Oracle monitoring: metadata pieces of library object found | ORA_PINHITS | DEC | 12 | ||
| PINHITRATIO | Oracle monitoring: The ratio of PINHITS to PINS | ORA_PINHITRATIO | DEC | 12 | ||
| RELOADS | Oracle monitoring: Reloads | ORA_RELOADS | DEC | 12 | ||
| INVALIDATIONS | Oracle monitoring: # of times objects were marked invalid | ORA_INVALIDATIONS | DEC | 12 | ||
| DLM_LOCK_REQUEST | Oracle monitoring: Number of DLM requests | ORA_DLM_REQUESTS | DEC | 12 | ||
| DLM_PIN_REQUESTS | Oracle monitoring:number of PIN requests lock instance locks | ORA_DLM_PIN_REQUESTS | DEC | 12 | ||
| DLM_PIN_RELEASES | Oracle monitoring:nb. of release requests PIN instance locks | ORA_DLM_PIN_RELEASES | DEC | 12 | ||
| DLM_INV_REQUESTS | Oracle monitoring:GET requests for invalidation instance lck | ORA_DLM_INVALIDATION_REQUESTS | DEC | 12 | ||
| DLM_INV | Oracle mon: invalidation pings received from other instances | ORA_DLM_INVALIDATIONS | DEC | 12 |