Re: adop cutover

Posted by ErmanArslansOracleBlog on Dec 30, 2016; 9:08am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adop-cutover-tp1817p1842.html

Bytheway,

setting job_queue_processes to 0 in such a situation is a cool move..
By this move, you are not letting MV refreshes to happen and this was your concern for the problematic MV.
However, job_queue_processes is used other places as well.
So, setting it to 0 is applicable for this specific problem, but care must be taken while setting it.