GVD_DB_CACHE_ADV - Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)
Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) information is stored in SAP table GVD_DB_CACHE_ADV.
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_DB_CACHE_ADV
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 | |
| ID | Oracle monitoring: db cache advice id | X | ORA_ID | DEC | 12 | |
| NAME | Oracle monitoring: db cache advice name | X | ORA_NAME_DB_CACHE_ADV | CHAR | 20 | |
| BLOCK_SIZE | Oracle monitoring: db cache advice block size | X | ORA_BLOCK_SIZE_DB_CACHE_ADV | DEC | 12 | |
| ADVICE_STATUS | Oracle monitoring: db cache advice status | X | ORA_ADVICE_STATUS_DB_CACHE_ADV | CHAR | 3 | |
| SIZE_FOR_ESTIMAT | Oracle monitoring: db cache advice size for estimate | X | ORA_SIZE_FOR_ESTIMATE | DEC | 12 | |
| SIZE_FACTOR | Oracle monitoring: db cache advice size factor | ORA_SIZE_FACTOR | DEC | 12 | ||
| BUFFERS_FOR_ESTI | Oracle monitoring: db cache advice buffers for estimate | ORA_BUFFERS_FOR_ESTIMATE | DEC | 12 | ||
| ESTD_PHYS_READ_F | Oracle monitoring: db cache advice physical read factor | ORA_ESTD_PHYSICAL_READ_FACTOR | DEC | 12 | ||
| ESTD_PHYS_READS | Oracle monitoring: db cache advice estd physical reads | ORA_ESTD_PHYSICAL_READS | DEC | 12 |