The PURGE_REFRESH_STATS procedure is used to forcibly delete materialized view refresh statistics that exceed the specified retention period.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
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 by commas. This parameter does not support specifying multiple materialized views at the same time.
|
| retention_period | The number of days for which statistics are retained. The value ranges from 1 to 365000. Statistics records exceeding this period are automatically deleted. The default value is 31 days.
|