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.

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”