Re: adop cutover

Posted by Linda on Dec 29, 2016; 2:29pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/adop-cutover-tp1817p1837.html

Hi Erman!
Thanks for help:) Setting job_queue_processes=0 and  all dropping all related objects including the MV# as well helped.
One more question: we have those custom MV on the EBS tables and refresh 1h..
Developers needed to change those as MV restrictions on Online patching -
no functions in mv views and NOT having subqueries in mv view Select part..
Those modifications causing in some cases big perf degradation as plsql functoins were helping in perf...

So, what do you think if we dont for some views implement OLP requirements on own risk.
That means during online patching, I will put ONHOLD the refresh  and in test I will see if the changes coming to those underlying MV EBS tables and if need to change MV itself after patching.
Anything I missing here ?
the patching after we are on 12.2.6+all needed patches should be done for next 1-2 years ( optimistic here) :)

Br,Linda