Database Administration (MOSC)

MOSC Banner

How to prevent materialized view refreshed time to be modified by downtime

edited Jun 22, 2023 4:43PM in Database Administration (MOSC) 1 commentAnswered

Hi

Database: Oracle 19c EE

Version: 19.17

OS: Redhat 8

I have many materialized views. To avoid CPU overload, I try to avoid refreshing them at the same time. But I noticed that after downtime, the refresh scheduled during downtime are all refreshed at the same time at startup.

Is there a way to prevent a refresh at startup if it was sheduled during a downtime? If a refresh is sheduled during a shutdown, I would like it to be skipped and and just wait next refresh time, not refresh time to be modified at startup.

Let's say I have a refresh group defined like

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center