6.226 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: