oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS

Purpose

The DBA_MVREF_STATS_SYS_DEFAULTS view displays the system-level default values of the statistics attributes for the history of materialized view refreshes.

Columns

Sample query

Query the system-level default values of the statistics attributes for the history of materialized view refreshes.

obclient [test_db]> SELECT * FROM oceanbase.DBA_MVREF_STATS_SYS_DEFAULTS;

The query result is as follows:

+------------------+---------+
| PARAMETER_NAME   | VALUE   |
+------------------+---------+
| COLLECTION_LEVEL | TYPICAL |
| RETENTION_PERIOD | 31      |
+------------------+---------+
2 rows in set