The DBMS_MVIEW_STATS system package provides an API for you to manage the collection and retention of materialized view refresh statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Privileges
You must have the EXECUTE privilege on the DBMS_MVIEW_STATS package to execute all subprograms in this package. By default, the SYSDBA role has the EXECUTE privilege on this package.
Subprograms
The following table describes the DBMS_MVIEW_STATS subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| PURGE_REFRESH_STATS | Automatically purges the materialized view refresh statistics that exceed the specified retention period. |
| SET_MVREF_STATS_PARAMS | Configures the collection level and retention period of materialized view refresh statistics. |
| SET_SYSTEM_DEFAULT | Sets the default values of refresh statistics parameters. |