patch upgradation from 9.2.0.6 to 9.2.0.8
661050Apr 16 2009 — edited Apr 22 2009Dear All,
Recently we have upgraded our database from 9.2.0.6 to 9.2.0.8. every thing went smooth.
After everything was over we have analyzed all the tables and indexes with sample size 5%.
Now we are facing performance issues with the optimizer. The optimizer for 9.2.0.8 is not picking the correct query execution plan and the query is running for long hours.
The problem is with the quries having the subqueries, and the subquery contains date column.
we have picked some queries which are having subqueries and with out date column in the subqueries. Those queries are working fine but the problem is with the subqueries having the date column.
is there any thing that we have to do for the optimiser so that optimiser can pick the corect execution plan.
Thanks in advance,
Raju