5.204 DBA_MVREF_STMT_STATS
DBA_MVREF_STMT_STATS
shows information associated with each refresh statement of a materialized view in a refresh run.
Related View
USER_MVREF_STMT_STATS
shows information associated with each refresh statement of a materialized view accessible to the current user in a refresh run.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the materialized view |
|
|
|
Name of the materialized view |
|
|
|
The refresh ID of the refresh run |
|
|
|
A number indicating the step in the refresh process in which the statement is executed for the materialized view. Steps are numbered consecutively starting at 1. |
|
|
|
The SQL ID of the statement |
|
|
|
The text of the SQL statement |
|
|
|
The time it took to execute the statement (in seconds) |
|
|
|
For internal use only |
See Also: