SET_SYSTEM_DEFAULT sets the system default value for the refresh statistics parameter.
Syntax
PROCEDURE set_system_default(
IN parameter_name VARCHAR(65535),
IN value VARCHAR(65535));
Parameters
Parameter |
Note |
|---|---|
| parameter_name | Parameter name. Valid values:
|
| value | When the parameter name is COLLECTION_LEVEL:
When the parameter name is RETENTION_PERIOD, the parameter value indicates the number of days for retaining statistics: 1 to 365000.
|