DBA_MVREF_CHANGE

5.199 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