The DBMS_MVIEW_STATS system package provides users with an interface to manage the collection and retention of statistics for materialized view refresh operations.
Overview of the DBMS_MVIEW_STATS Subprogram
The following table lists the DBMS_MVIEW_STATS subprograms supported by the current version of OceanBase AI Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| PURGE_REFRESH_STATS | This statement is used to force the automatic deletion of materialized views that exceed the specified retention period and refresh their statistics. |
| SET_MVREF_STATS_PARAMS | The parameters used to configure the collection level and data retention period for materialized view refresh statistics. |
| SET_SYSTEM_DEFAULT | Sets the system default value for the statistics refresh parameter. |