Currently after upgrading, we had multiple query level performance issues and we have tuned those by adding indexes and changing the sql profile as suggested by tuning advisor.

Now when multiple application uses same modules in application (same set of sqls executed in DB), we are experiencing performance issues.

So now if we change the optimizer to 11.2.0.3, what will be the impact to the queries we have already tuned after 11.2.0.4 upgrade.

Thanks

As mentioned, I have a process which runs fine one day and gives problem the other day due to bad plans.

Could you please guide us how to store the good day plans and direct optimizer to chose the same for further executions.

Thanks

Thanks for the update.

Since we are seeing these optimizer and SQL plan issues after the upgrade of 11.2.0.3 to 11.2.0.4.

Would you suggest any DB level parameters/underscore parameters that we need to look into.

thanks

alter session set events = '10053 trace name context forever, level 1'
select * from dual;