Materialized View Refresh: Locking, Performance, Monitoring (Doc ID 258252.1)

Last updated on MAY 14, 2024

Applies to:

The purpose of this article is to provide an understanding of the locking and
performance issue related to materialized view refreshes. How a refresh
process can impact and be impacted by other refresh processes and user
processes is also discussed. This article also provides some basic queries
that can be used to monitor materialized view refreshes.

Scope

This article is intended for DBA's and support analysts who are familiar with
distributed materialized view concepts. <NOTE:258021.1> How to monitor the
progress of a materialized view refresh can be reviewed along with this article
to gain a full understanding of the materialized view refresh process.

The information in this article is specific to distributed materialized views.
While much of the information is applicable to local materialized views, there
may be differences in locking and performance expectations for local
materialized views. For information specific to local materialized view
refreshes, please see the Oracle Data Warehousing Manual.

From this point on, the term 'mview' will be used in place of 'materialized
view'.

'Materialized view' and 'Snapshot' are synonymous as of 8i.

Details