Re: 10G and RULE
From: Nicolas Bronke <Nicolas_Bronke_at_web.de>
Date: Wed, 7 Apr 2010 09:39:02 +0200
Message-ID: <822r4nFj19U1_at_mid.individual.net>
>> 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?
>
>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?
Date: Wed, 7 Apr 2010 09:39:02 +0200
Message-ID: <822r4nFj19U1_at_mid.individual.net>
>> 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?
>
>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?
in addition to my answer to mark.
We do not use dblinks. We often let analyze the data.
Regards
Nicolas
Received on Wed Apr 07 2010 - 02:39:02 CDT