GVD_ROWCACHE - Oracle monitoring: Copy of GV$ROWCACHE
Oracle monitoring: Copy of GV$ROWCACHE information is stored in SAP table GVD_ROWCACHE.
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_ROWCACHE
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 | |
| CACHE_NR | Oracle Monitoring: CACHE# | X | ORA_CACHE | DEC | 12 | |
| TYPE | Oracle Monitoring: Parent or subordinate row cache type | X | ORA_TYPE_ROW | CHAR | 11 | |
| SUBORDINATE | Oracle Monitoring: Subordinate set number | X | ORA_SUBORDINATE | DEC | 12 | |
| PARAMETER_ROW | Oracle monitoring: Name of the initialization parameter | ORA_PARAMETER_ROW | CHAR | 32 | ||
| COUNT_ROW | Oracle monitoring: COUNT | ORA_COUNT | DEC | 12 | ||
| USAGE_ROW | Oracle monitoring: Number of cache entries that contain vali | ORA_USAGE | DEC | 12 | ||
| FIXED | Oracle monitoring: Number of fixed entries in the cache | ORA_FIXED | DEC | 12 | ||
| GETS | Oracle monitoring: Total number of requests for information | ORA_GETS_CACHE | DEC | 12 | ||
| GETMISSES | Oracle monitoring: Number of data requests resulting in cach | ORA_GET_MISSES | DEC | 12 | ||
| SCANS | Oracle monitoring: Number of scan requests | ORA_SCANS | DEC | 12 | ||
| SCANMISSES | Oracle monitoring: # scan failed to find data in cache | ORA_SCANMISSES | DEC | 12 | ||
| SCANCOMPLETES | Oracle monitoring: number of times the list was scanned comp | ORA_SCANCOMPLETES | DEC | 12 | ||
| MODIFICATIONS | Oracle monitoring: Number of inserts, updates, and deletions | ORA_MODIFICATIONS | DEC | 12 | ||
| FLUSHES | Oracle monitoriing: Number of times flushed to disk | ORA_FLUSHES | DEC | 12 | ||
| DLM_REQUESTS | Oracle monitoring: Number of DLM requests | ORA_DLM_REQUESTS | DEC | 12 | ||
| DLM_CONFLICTS | Oracle monitoring: Number of DLM conflicts | ORA_DLM_CONFLICTS | DEC | 12 | ||
| DLM_RELEASES | Oracle monitoring: Number of DLM releases | ORA_DLM_RELEASES | DEC | 12 |