My Oracle Support Banner

Materialized View Generating Huge Amount Of Redo And Archived Logs During Complete Refresh (Doc ID 2461550.1)

Last updated on OCTOBER 22, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Goal

A Materialized View is generating a huge amount of redo data during full refresh process causing the Fast Recovery Area (FRA) to get full.

What are the options to minimize redo generation during full Materialized View refresh process?

Can atomic_refresh value be changed to false?
What are pros and cons if this feature?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.