Re: Different results for the same query in 10g and 11g
Date: Wed, 18 Apr 2012 06:17:38 -0700 (PDT)
I had a same kind of problem. What versions are you using ? There are many bugs in 22.214.171.124. I was told to upgrade to 126.96.36.199 and after that I got the right result.
When using 10.2.0.4 optimizer in 11g database I got the same result as in 10g. You could try SELECT /*+ OPTIMIZER_FEATURES_ENABLE('10.2.0.4') */ hint in you query in 11g.
Maija-Leena Received on Wed Apr 18 2012 - 15:17:38 CEST