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
prashas_d
Messages: 65
Registered: February 2007
Member
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.

prashas_d.
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: 59082
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Different way depending on how you refresh:
ALTER MATERIALIZED VIEW
DBMS_REFRESH.CHANGE
DBMS_JOB.BROKEN on the job that refreshes.

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


Current Time: Tue Sep 16 07:02:02 CDT 2014

Total time taken to generate the page: 0.08340 seconds