Wouldn’t you agree?
My colleagues from the Optimizer Development might forgive me but a lot of people would say: “Everything went fine after upgrade – except for those tiny 3 queries!”. And I know, you have tested a lot. I’d like to tell you about a few issues we’ve seen post upgrade with 22.214.171.124.
- You have captured your plans in Oracle 10.2 pre-upgrade.
- You have moved these plans from your SQL Tuning Set into the SQL Plan Baseline in Oracle 11.2.
- But the optimizer doesn’t pick them although you have:
(a) ACCEPTED and
(b) FIXED them.
It …Continue reading...