The SET_SYSTEM_DEFAULT procedure sets the default values of refresh statistics parameters.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_MVIEW_STATS.SET_SYSTEM_DEFAULT (
parameter_name IN VARCHAR2,
value IN VARCHAR2);
DBMS_MVIEW_STATS.SET_SYSTEM_DEFAULT (
parameter_name IN VARCHAR2,
value IN NUMBER);
Parameters
| Parameter |
Description |
| parameter_name |
The parameter name. Valid values:
COLLECTION_LEVEL: the statistics collection level. The default value is TYPICAL.
RETENTION_PERIOD: the retention period (in days) of statistics. The default value is 31 days. |
| value |
When parameter_name is COLLECTION_LEVEL, the parameter value indicates the collection level. Valid values:
NONE: specifies not to collect statistics.
TYPICAL: specifies to collect basic refresh statistics.
ADVANCED: specifies to collect detailed refresh statistics.
NULL: specifies to use the default value, that is, TYPICAL. When parameter_name is RETENTION_PERIOD, the parameter value indicates the retention period (in days) of statistics, which ranges from 1 to 365,000 days.
NULL: specifies to use the default value.
-1: specifies to permanently retain statistics.
|
