How to prevent materialized view refreshed time to be modified by downtime
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