8.9 V$ACTIVITY_MVIEW
V$ACTIVITY_MVIEW
describes the materialized view activity snapshots that are currently being taken by the Object Activity Tracking System (OATS).
Each row in this view represents one in-progress activity snapshot and describes the materialized view activity that has occurred so far during the snapshot interval.
Column | Datatype | Description |
---|---|---|
|
|
Name of the materialized view for which the activity snapshot is being taken |
|
|
Owner of the materialized view for which the activity snapshot is being taken |
|
|
Indicates whether the activity was performed by the RDBMS ( |
|
|
Number of times the materialized view was compiled This number includes:
|
|
|
Number of query rewrites that used the text match rewrite method |
|
|
Number of query rewrites that used general rewrite methods |
|
|
Number of query rewrites that occurred when the view was partially stale This number includes:
|
|
|
Number of query rewrites that used stale data in the materialized view plus the delta information stored in the materialized view logs |
|
|
Number of partition change tracking (PCT) rewrites |
|
|
Number of query rewrites that occurred because the materialized view was eligible for query rewrite and the |
|
|
Reserved for future use |
|
|
Number of query executions that did not use query rewrite because the materialized view was eligible for query rewrite, but stale |
|
|
Number of This type of refresh is performed on materialized views that use the |
|
|
Number of This type of refresh is performed on materialized views that use the |
|
|
Number of This type of refresh is performed on materialized views that use the |
|
|
Number of scheduled refreshes |
|
|
Number of automatic refreshes |
|
|
Number of incremental refreshes |
|
|
Number of full refreshes |
|
|
Number of partition change tracking (PCT) refreshes |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
The counts in this view are approximate in order to keep system overhead low. Also, there are database activities, such as statistics collection, query compilation, and query optimization, that may cause the counts to be different than expected or to vary slightly across successive queries.
Note:
This view is available starting with Oracle Database 21c.
See Also:
"DBA_ACTIVITY_MVIEW" to view recently completed materialized view activity snapshots