Overview of DBMS_MVIEW_STATS
The DBMS_MVIEW_STATS system package provides an interface for users to manage the collection and retention of statistics for materialized view refresh operations.
Overview of DBMS_MVIEW_STATS subprograms
The following table lists the DBMS_MVIEW_STATS subprograms supported by seekdb and their brief descriptions.
| Subprogram | Description |
|---|---|
| PURGE_REFRESH_STATS | Forcibly deletes materialized view refresh statistics that exceed the specified retention period. |
| SET_MVREF_STATS_PARAMS | Configures parameters for the collection level and data retention period of materialized view refresh statistics. |
| SET_SYSTEM_DEFAULT | Sets the system default values for refresh statistics parameters. |