Re: performance issues

Posted by ErmanArslansOracleBlog on Nov 02, 2023; 1:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/performance-issues-tp12142p12154.html

This may be due to some SQL plans, which might be changed after 19C upgrade..
You need to work with your developers to make those run as they should. Especially for the custom code. Your developers are responsible too. This is an upgrade and your query optimizer changed.
Actually you should have tested all these before doing such an upgrade.

Currently, your performance issue is generic and broad. Hands-on work is needed for fixing your issue.. It requires analysis, and actions.
If you need consultancy, contact our sales team -> [e-mail]

Still, see my latest update.. The latest line ->

--See the end of the AWR report.
--You got sql tuning recommendations under the title ADDM Task ADDM:3107712059_1_11453 for those relevant SQLs. Consider the recommendation given there.