The SET_MVREF_STATS_PARAMS procedure configures the collection level and retention period of materialized view refresh statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_MVIEW_STATS.SET_MVREF_STATS_PARAMS (
mv_list IN VARACHAR2,
collection_level IN VARCHAR2 DEFAULT NULL,
retention_period IN NUMBER DEFAULT NULL);
Parameters
| Parameter | Description |
|---|---|
| mv_list | A list of materialized view names separated with commas (,). You can specify only one materialized view at a time in the current version.
|
| collection_level | The collection level of statistics. The default value is TYPICAL. Valid values:
|
| retention_period | The statistics retention period, which ranges from 1 to 365,000 days. The default value is 31 days. The system automatically purges statistics that exceed the specified retention period.
|