Home » Server Options » Replication » Pausing and Resuming of refreshing Materialised views (Oracle 11)
Pausing and Resuming of refreshing Materialised views [message #527160] Sat, 15 October 2011 22:53 Go to next message
Messages: 66
Registered: February 2007
Hi All,

We have some materialised views in our environment which refeshes after every 1 hour. In the same environment, we have some big processes and we do not want the performance of these big processes to get affected because of refreshing these materialised views.

Could you please let me know if there is a way to pause the refreshing of materialised views before running the big processes and later after the big processes are completed, then resume the refreshing of the materialised views?

One way I can think of is to drop the materialised views and create the materialised views back.

Thanks for your help in advance.

Re: Pausing and Resuming of refreshing Materialised views [message #527166 is a reply to message #527160] Sun, 16 October 2011 00:45 Go to previous message
Michel Cadot
Messages: 68165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Different way depending on how you refresh:
DBMS_JOB.BROKEN on the job that refreshes.

Previous Topic: Error in refreshing MV
Next Topic: Materialized Views Help
Goto Forum:

Current Time: Thu May 19 22:45:59 CDT 2022