Re: 10G and RULE
From: Nicolas Bronke <Nicolas_Bronke_at_web.de>
Date: Wed, 7 Apr 2010 09:36:53 +0200
Message-ID: <822r0mFi80U1_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?
>>
>An actual example SQL showing both versions wtih results and the
>explain plan would likely be helpful. Also information on the type of
>table: heap, IOT, partitioned involved in the query is useful.
>
>We have 10.2.0.3 and have not seen this.
>
>Performance issues are common after upgrading to 10g from a lower
>version but changes in the query results are not.
Date: Wed, 7 Apr 2010 09:36:53 +0200
Message-ID: <822r0mFi80U1_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?
>>
>An actual example SQL showing both versions wtih results and the
>explain plan would likely be helpful. Also information on the type of
>table: heap, IOT, partitioned involved in the query is useful.
>
>We have 10.2.0.3 and have not seen this.
>
>Performance issues are common after upgrading to 10g from a lower
>version but changes in the query results are not.
Thank you. I could not answer earlier.
The problem is, that the sql is very specific (depends also from session
variables) and it seems, that the problem only occurs with a number of data
(or complexity of data).
I think we will ow look a little more deeper in the explain plan.
Regards
Nicolas
Received on Wed Apr 07 2010 - 02:36:53 CDT