Materialized View Refresh : Log Population and Purge
(Doc ID 236233.1)
Last updated on FEBRUARY 22, 2019
Oracle Database Cloud Schema Service - Version N/A and later Oracle Database Exadata Cloud Machine - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Oracle Database Exadata Express Cloud Service - 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!