Migrate 9i sql plan to a 11g DB
Hi
We recently upgraded our 9i (9.2.0.8) database to 11.2.0.3.
One of the sql queries cost just 132 on the 9i database and cost 294,746 on the 11g database.
I tried to gather stats at 100 percent on the schema and also on the key tables. I did this on one of our non-prod instances. The cost has come down to around 240000, way above the 132 on the 9i database?
Is there a way for me to export the 9i plan to the 11g and include it as part of the baseline.
Thanks for your help.
-jajohn