Re: 10G and RULE
From: joel garry <joel-garry_at_home.com>
Date: Sun, 21 Mar 2010 09:52:33 -0700 (PDT)
Message-ID: <664c313d-ce4c-4ecf-8f46-3d68c82a1171_at_k36g2000prb.googlegroups.com>
On Mar 20, 4:41 am, "Nicolas Bronke" <Nicolas_Bro..._at_web.de> wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work correcly.
> No rows are returned. If I put the RULE back in this query everything works
> fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
Date: Sun, 21 Mar 2010 09:52:33 -0700 (PDT)
Message-ID: <664c313d-ce4c-4ecf-8f46-3d68c82a1171_at_k36g2000prb.googlegroups.com>
On Mar 20, 4:41 am, "Nicolas Bronke" <Nicolas_Bro..._at_web.de> wrote:
> With Oracle 10g the RULE command will not be supported.
> So far as good, we removed all RULE statements inside Queries and views.
> Mostly it works fine, but in some cases the queries does not work correcly.
> No rows are returned. If I put the RULE back in this query everything works
> fine.
> This happens with 20g2.0.3 and 10g2.0.4
>
> Does someone else has seen this and does exist a patch for this behaviour?
>
> Regards
> Nicolas
In addition to what Mark said, see the 10.2.0.4 and 11g notes that list all the bugfixes for all the patches. There are some CBO wrong results bugs that aren't fixed until 11g, but they tend to be really obscure. Are you using dblinks? How _exactly_ are you gathering statistics?
jg
-- _at_home.com is bogus. http://www.signonsandiego.com/news/2010/mar/20/small-crowd-at-floatopia-party-so-far/Received on Sun Mar 21 2010 - 11:52:33 CDT