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

TBL_OWNER

VARCHAR2(128)

NOT NULL

Owner of the master table for the materialized view

TBL_NAME

VARCHAR2(128)

NOT NULL

Name of the master table for the materialized view

MV_OWNER

VARCHAR2(128)

NOT NULL

Owner of the materialized view

MV_NAME

VARCHAR2(128)

NOT NULL

Name of the materialized view

REFRESH_ID

NUMBER

NOT NULL

The refresh ID of the refresh run

NUM_ROWS_INS

NUMBER

The number of inserts in the materialized view log of the table (applicable only if the table has a materialized view log)

NUM_ROWS_UPD

NUMBER

The number of updates in the materialized view log of the table (applicable only if the table has a materialized view log)

NUM_ROWS_DEL

NUMBER

The number of deletes in the materialized view log of the table (applicable only if the table has a materialized view log)

NUM_ROWS_DL_INS

NUMBER

The number of direct load inserts on the table

PMOPS_OCCURRED

CHAR(1)

Indicates whether a partition-maintenance operation (PMOP) occurred. Possible values:

  • Y

  • N

  • NULL: Indicates an unknown value

PMOP_DETAILS

VARCHAR2(4000)

Details of the PMOPs in the following format:

  • TRUNCATE (low_bound, high_bound)

  • EXECHANGE (low_bound, high_bound)

NUM_ROWS

NUMBER

The number of rows in the table at the start of the refresh operation

See Also:

“USER_MVREF_CHANGE_STATS”


数据运维技术 » Oracle 视图 DBA_MVREF_CHANGE_STATS 官方解释,作用,如何使用详细说明