Oracle 视图 DBA_MVREF_CHANGE_STATS 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图DBA_MVREF_CHANGE_STATS保存了特定的物化视图上次刷新以来的更改统计信息,它包括物化视图名称,刷新时间和更改统计信息,帮助DBA理解更改的范围和发生时间。
这个视图可以用来帮助DBA了解他们正在管理的数据库中物化视图查询的变化情况,以及物化视图上次刷新以来发生的更改。
可以使用下面的SQL查询来查询DBA_MVREF_CHANGE_STATS视图:
SELECT * FROM DBA_MVREF_CHANGE_STATS;
官方英文解释
DBA_MVREF_CHANGE_STATS
displays the change data load information on the base tables associated with a refresh run for all the materialized views for the database.
Related View
USER_MVREF_CHANGE_STATS
displays the change data load information on the master tables associated with a refresh run for all the materialized views in the database that are accessible to the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the master table for the materialized view |
|
|
|
Name of the master table for the materialized view |
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
The refresh ID of the refresh run |
|
|
The number of inserts in the materialized view log of the table (applicable only if the table has a materialized view log) |
|
|
|
The number of updates in the materialized view log of the table (applicable only if the table has a materialized view log) |
|
|
|
The number of deletes in the materialized view log of the table (applicable only if the table has a materialized view log) |
|
|
|
The number of direct load inserts on the table |
|
|
|
Indicates whether a partition-maintenance operation (PMOP) occurred. Possible values:
|
|
|
|
Details of the PMOPs in the following format:
|
|
|
|
The number of rows in the table at the start of the refresh operation |
See Also:
“USER_MVREF_CHANGE_STATS”