DBA_MVREF_STATS_SYS_DEFAULTS

Purpose

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

Columns

Sample query

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

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

The query result is as follows:

+------------------+---------+
| PARAMETER_NAME   | VALUE   |
+------------------+---------+
| COLLECTION_LEVEL | TYPICAL |
| RETENTION_PERIOD | 31      |
+------------------+---------+
2 rows in set (0.007 sec)