GVD_SGADYNCOMP - Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON
Oracle monitoring: Snapshot table for GV$SGA_DYNAMIC_COMPON information is stored in SAP table GVD_SGADYNCOMP.
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_SGADYNCOMP
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 | |
| COMPONENT | Oracle monitoring:COMPONENT:Component name | X | ORA_COMPONENT | CHAR | 64 | |
| CURRENT_SIZE | Oracle monitoring:CURRENT_SIZE:Current value of the paramete | ORA_CURRENT_SIZE | DEC | 12 | ||
| MIN_SIZE | Oracle monitoring:MIN_SIZE:Minimum size of the component | ORA_MIN_SIZE | DEC | 12 | ||
| MAX_SIZE | Oracle monitoring:MAX_SIZE:Maximum size of the component | ORA_MAX_SIZE | DEC | 12 | ||
| OPER_COUNT | Oracle monitoring:OPER_COUNT:Number of ops. since startup | ORA_OPER_COUNT | DEC | 12 | ||
| LAST_OPER_TYPE | Oracle monitoring:LAST_OPER_TYPE:Last completed operation | ORA_LAST_OPER_TYPE | CHAR | 6 | ||
| LAST_OPER_MODE | Oracle monitoring:LAST_OPER_MODE:Mode of last completed op. | ORA_LAST_OPER_MODE | CHAR | 6 | ||
| LAST_OPER_TIME | Oracle monitoring:LAST_OPER_TIME:Start time of the last comp | ORA_LAST_OPER_TIME | TIMS | 6 | ||
| LAST_OPER_DATE | Oracle monitoring:LAST_OPER_TIME:Start date of the last comp | ORA_LAST_OPER_DATE | DATS | 8 | ||
| GRANULE_SIZE | Oracle monitoring:GRANULE_SIZE:Granularity of the grow or th | ORA_GRANULE_SIZE | DEC | 12 |