GVD_SPPARAMETER - Oracle Monitoring: Copy of GV$SPPARAMETER
Oracle Monitoring: Copy of GV$SPPARAMETER information is stored in SAP table GVD_SPPARAMETER.
It is part of development package S_DBMON_ORA_COCKPIT in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle in Cockpit Framework".
It is part of development package S_DBMON_ORA_COCKPIT in software component BC-CCM-MON-ORA. This development package consists of objects that can be grouped under "Database Monitor for Oracle in Cockpit Framework".
Fields for table GVD_SPPARAMETER
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 | |
| SID | Oracle Monitoring: SID: SID for which param is defined | X | ORA_PARAM_SID | CHAR | 80 | |
| NAME | Oracle Monitoring: NAME: Name of the parameter | X | ORA_PARAM_NAME | CHAR | 80 | |
| ORDINAL | Oracle Monitoring: ORDINAL: Position of the param value | X | ORA_ORDINAL | DEC | 12 | |
| VALUE | Oracle monitoring: Parameter value | ORA_SP_VALUE | CHAR | 255 | ||
| ISSPECIFIED | Oracle Monitoring: ISSPECIFIED: Is the param in th SP file | ORA_ISSPECIFIED | CHAR | 6 | ||
| UPDATE_COMMENT | Oracle monitoring: Comments due to the most recent update | ORA_UPDATE_COMMENT | CHAR | 255 |