As we are well known that whole technology is getting change towards advancement. All things are working on automatic. Even software works on autonomous. In RDBMS we have a feature to stop automatic refresh MView.

 

 

 

Let’s have look how do we stop automatic refresh MView 

Connect as mview owner.

select * from user_jobs where broken ='N';

You will see mview refresh job in WHAT column:

dbms_refresh.refresh('"[OWNER]"."[MVIEW_NAME]"');

We execute the following command using the JOB_ID that you can see from the output of the above statement:

begin
dbms_job.run(JOB_ID);
commit;
end;
/

Example:

begin
dbms_job.broken(116,TRUE);
commit;
end;
/

Code for Start Refresh again:

begin
dbms_job.run(JOB_ID);
commit;
end;
/

Example:

begin
dbms_job.broken(116,FALSE);
commit;
end;
/

MVIEW will start refreshing again.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.