The PURGE_REFRESH_STATS procedure forces the automatic purge of materialized view refresh statistics that exceed the specified retention period.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_MVIEW_STATS.PURGE_REFRESH_STATS (
mv_list IN VARACHAR2,
retention_period IN NUMBER);
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.
|
| 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.
|