GVD_PARAMETER2 - Copy of GV$PARAMETER2 (currently not provided with snapshot
Copy of GV$PARAMETER2 (currently not provided with snapshot information is stored in SAP table GVD_PARAMETER2.
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_PARAMETER2
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 | |
NUM | Oracle Monitoring: NUM: Parameter Number | X | ORA_PARAM2_NUM | DEC | 12 | |
ORDINAL | Oracle Monitoring: ORDINAL: Position of the param value | X | ORA_ORDINAL | DEC | 12 | |
NAME | Oracle Monitoring: NAME: Parameter Name | ORA_PARAM2_NAME | CHAR | 64 | ||
TYPE | Oracle Monitoring: TYPE: Parameter Type | ORA_PARAM2_TYPE | DEC | 12 | ||
ISDEFAULT | Oracle Monitoring: ISDEFAULT: Is param set to default value | ORA_ISDEFAULT2 | CHAR | 6 | ||
ISSES_MODIFIABLE | Oracle Monitoring: ISSES_MODIFIABLE | ORA_ISSES_MODIFIABLE2 | CHAR | 5 | ||
ISSYS_MODIFIABLE | Oracle Monitoring: Is parameter changeable by ALTER SYSTEM | ORA_ISSYS_MODIFIABLE2 | CHAR | 9 | ||
ISMODIFIED | Oracle monitoring: Parameter modified after instance start ? | ORA_ISMODIFIED2 | CHAR | 10 | ||
ISADJUSTED | Oracle monitoring: Oracle adjusted the input value ? | ORA_ISADJUSTED2 | CHAR | 5 | ||
DESCRIPTION | Oracle monitoring: Description | ORA_DESCRIPTION2 | CHAR | 64 | ||
UPDATE_COMMENT | Oracle monitoring: Comments due to the most recent update | ORA_UPDATE_COMMENT2 | CHAR | 255 | ||
VALUE_LENGTH | Oracle Monitoring: Field to store length of long char types | ORA_TEXT_LENGTH | INT4 | 4 | ||
VALUE | Oracle Monitoring: VALUE: Parameter Value for the Session | ORA_PARAM2_VALUE | LCHR | 512 |