GVD_SHAR_P_ADV - Oracle Monitoring: Copy of gv$shared_pool_advice
Oracle Monitoring: Copy of gv$shared_pool_advice information is stored in SAP table GVD_SHAR_P_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_SHAR_P_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 | |
| SHARED_POOL_SFE | Oracle Monitoring: SHARED_POOL_SIZE_FOR_ESTIMATE | X | ORA_SHARED_POOL_SFE | DEC | 12 | |
| SHARED_POOL_SF | Oracle Monitoring: SHARED_POOL_SIZE_FACTOR | ORA_SHARED_POOL_SF | DEC | 12 | ||
| ESTD_LC_SIZE | Oracle Monitoring: ESTD_LC_SIZE | ORA_ESTD_LC_SIZE | DEC | 12 | ||
| ESTD_LC_MEMORY_O | Oracle Monitoring: ESTD_LC_MEMORY_OBJECTS | ORA_ESTD_LC_MEMORY_OBJECTS | DEC | 12 | ||
| ESTD_LC_TIME_S | Oracle Monitoring: ESTD_LC_TIME_SAVED | ORA_ESTD_LC_TIME_SAVED | DEC | 12 | ||
| ESTD_LC_TIME_SF | Oracle Monitoring: ESTD_LC_TIME_SAVED_FACTOR | ORA_ESTD_LC_TIME_SAVED_FACTOR | DEC | 12 | ||
| ESTD_LC_MEMORY_H | Oracle Monitoring: ESTD_LC_MEMORY_OBJECT_HITS | ORA_ESTD_LC_MEMORY_OBJECT_HITS | DEC | 12 |