Re: Different results for the same query in 10g and 11g
From: <kangasmaki_at_netti.fi>
Date: Wed, 18 Apr 2012 06:17:38 -0700 (PDT)
Message-ID: <18516615.315.1334755058536.JavaMail.geo-discussion-forums_at_vbhy1>
Date: Wed, 18 Apr 2012 06:17:38 -0700 (PDT)
Message-ID: <18516615.315.1334755058536.JavaMail.geo-discussion-forums_at_vbhy1>
Hi,
I had a same kind of problem. What versions are you using ?
There are many bugs in 11.2.0.1. I was told to upgrade to 11.2.0.3 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.
Regards,
Maija-Leena Received on Wed Apr 18 2012 - 15:17:38 CEST