Showing posts with label Materialized View Job SCHEDULER. Show all posts
Showing posts with label Materialized View Job SCHEDULER. Show all posts
Saturday, March 13, 2021
Materialized View Job SCHEDULER
During cutover activity there should not be any Materialized View Job in running state to avoid the delay.
Below are the scripts to check the running MV’s and to stop the Jobs.
Please note Materialized View Job name will start with MV.
1.
SELECT * FROM DBA_SCHEDULER_RUNNING_JOBS;
2.
BEGIN
DBMS_SCHEDULER.STOP_JOB(job_name => 'MV_RF$J_0_S_116418', force => true);
END;
/
Subscribe to:
Posts (Atom)