Re: Upgrade ebsR12.1.3 database 11.1.0.7 to 11.2.0.4

Posted by ErmanArslansOracleBlog on Oct 30, 2022; 7:28pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Upgrade-ebsR12-1-3-database-11-1-0-7-to-11-2-0-4-tp11161p11183.html

We need to see a trace.. or you should rerun this upgrade in your TEST environment you should check the sessions and see the queries they re executing and tell us.. (query + execution plan + description of the relevant table(s)) 11.1.0.7 is an old release, I hope the cause to be found is not a complex one..

Lack of stats may be the cause, lots of data (more than your hw resources can handle) in your spatial tables may be the cause, a bug can be the cause.. Without data(diag data), only an Oracle can know it :)

Note that; there are some bugs around this subject (spatial & upgrade ) -> Slow Performance On Database Upgrade with Spatial Data (Doc ID 2477788.1)