SET_SYSTEM_DEFAULT

最終更新:2026-09-03 07:23:58

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.

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.

次のトピック

What's New