Materialized View Refresh : Log Population and Purge
(Doc ID 236233.1)
Last updated on JUNE 13, 2023
Oracle Database Cloud Service - Version N/A and later Oracle Database Backup Service - Version N/A and later Oracle Database - Enterprise Edition - Version 220.127.116.11 and later Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform.
The purpose of this article is to explain Oracle's materialized view fast refresh mechanism. It also discusses the performance, problems related to materialized view log management.
NB: The terms Snapshot and Materialized View are synonymous.
This is for customers of all levels of expertise in dealing with materialized views.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!