SAP Table GVD_DB_CACHE_ADV
Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table GVD_DB_CACHE_ADV (Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps)) is a standard table in SAP ERP. It belongs to the package STUN.
Technical Information
| Table | GVD_DB_CACHE_ADV |
| Short Text | Copy of GV$DB_CACHE_ADVICE (currently not provided w. snaps) |
| Package | STUN |
| Table Type | Transparent Table |
Fields for Table GVD_DB_CACHE_ADV
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SNAPSHOT_ID | ✔ | Oracle monitor: snapshot ID | ORA_SNAPSHOT_ID | NUMC | 10 | * |
| INST_ID | ✔ | Oracle monitor: Instance ID | ORA_INST_ID | DEC | 22 | |
| ID | ✔ | Oracle monitoring: db cache advice id | ORA_ID | DEC | 22 | |
| NAME | ✔ | Oracle monitoring: db cache advice name | ORA_NAME_DB_CACHE_ADV | CHAR | 20 | |
| BLOCK_SIZE | ✔ | Oracle monitoring: db cache advice block size | ORA_BLOCK_SIZE_DB_CACHE_ADV | DEC | 22 | |
| ADVICE_STATUS | ✔ | Oracle monitoring: db cache advice status | ORA_ADVICE_STATUS_DB_CACHE_ADV | CHAR | 3 | |
| SIZE_FOR_ESTIMAT | ✔ | Oracle monitoring: db cache advice size for estimate | ORA_SIZE_FOR_ESTIMATE | DEC | 22 | |
| SIZE_FACTOR | Oracle monitoring: db cache advice size factor | ORA_SIZE_FACTOR | DEC | 22 | ||
| BUFFERS_FOR_ESTI | Oracle monitoring: db cache advice buffers for estimate | ORA_BUFFERS_FOR_ESTIMATE | DEC | 22 | ||
| ESTD_PHYS_READ_F | Oracle monitoring: db cache advice physical read factor | ORA_ESTD_PHYSICAL_READ_FACTOR | DEC | 22 | ||
| ESTD_PHYS_READS | Oracle monitoring: db cache advice estd physical reads | ORA_ESTD_PHYSICAL_READS | DEC | 22 |