GVD_SGARESIZEOPS - Oracle Monitoring: Copy of GV$SGA_RESIZE_OPS
Oracle Monitoring: Copy of GV$SGA_RESIZE_OPS information is stored in SAP table GVD_SGARESIZEOPS.
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_SGARESIZEOPS
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_SGA_COMPONENT | CHAR | 64 | |
| OPER_TYPE | Oracle monitoring:OPER_TYPE:Operation type | ORA_SGA_OPER_TYPE | CHAR | 6 | ||
| OPER_MODE | Oracle monitoring:OPER_MODE:Operation mode | ORA_SGA_OPER_MODE | CHAR | 6 | ||
| PARAM | Oracle monitoring:PARAMETER:Parameter for the resize op. | ORA_SGA_PARAMETER | CHAR | 64 | ||
| INITIAL_SIZE | Oracle monitoring:INITIAL_SIZE:Parameter value at the start | ORA_SGA_INITIAL_SIZE | DEC | 12 | ||
| TARGET_SIZE | Oracle monitoring:TARGET_SIZE:Desired value of the parameter | ORA_SGA_TARGET_SIZE | DEC | 12 | ||
| FINAL_SIZE | Oracle Monitoring: FINAL_SIZE: Real value after resize | ORA_FINAL_SIZE | DEC | 12 | ||
| STATUS | Oracle Monitoring: STATUS: Completion status of operation | ORA_SGA_STATUS | CHAR | 9 | ||
| START_DATE | Oracle Monitoring: START_DATE: Start date of operation | ORA_SGA_START_DATE | DATS | 8 | ||
| START_TIME | Oracle Monitoring: START_TIME: Start time of operation | ORA_SGA_START_TIME | TIMS | 6 | ||
| END_DATE | Oracle Monitoring: END_DATE: End date of operation | ORA_SGA_ENDDATE | DATS | 8 | ||
| END_TIME | Oracle Monitoring: END_TIME: End time of operation | ORA_SGA_ENDTIME | TIMS | 6 |