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>



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 - 08:17:38 CDT

Original text of this message