GVD_SGACURRRESIZ - Oracle monitoring: Snapshot table for GV$SGA_CURRENT_RESIZE
Oracle monitoring: Snapshot table for GV$SGA_CURRENT_RESIZE information is stored in SAP table GVD_SGACURRRESIZ.
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_SGACURRRESIZ
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 | |
| OPER_TYPE | Oracle monitoring:OPER_TYPE:Operation type | ORA_OPER_TYPE | CHAR | 6 | ||
| OPER_MODE | Oracle monitoring:OPER_MODE:Operation mode | ORA_OPER_MODE | CHAR | 6 | ||
| OPARAMETER | Oracle monitoring:PARAMETER:Parameter for the resize op. | ORA_PARAMETER | CHAR | 64 | ||
| INITIAL_SIZE | Oracle monitoring:INITIAL_SIZE:Parameter value at the start | ORA_INITIAL_SIZE | DEC | 12 | ||
| TARGET_SIZE | Oracle monitoring:TARGET_SIZE:Desired value of the parameter | ORA_TARGET_SIZE | DEC | 12 | ||
| CURRENT_SIZE | Oracle monitoring:CURRENT_SIZE:Current value of the paramete | ORA_CURRENT_SIZE | DEC | 12 | ||
| START_TIME | Oracle monitoring:START_TIME:Start time of the operation | ORA_START_TIME | CHAR | 20 | ||
| START_DATE | StarOracle monitoring:START_TIME:Start date of the operation | ORA_START_DATE | DATS | 8 | ||
| LAST_UPDATE_TIME | Oracle monitoring:LAST_UPDATE_TIME:Last time progress was ma | ORA_LAST_UPDATE_TIME | TIMS | 6 | ||
| LAST_UPDATE_DATE | Oracle monitoring:LAST_UPDATE_TIME:Last time progress was ma | ORA_LAST_UPDATE_DATE | DATS | 8 |