Re: Scary 10gR2 query problem

See if the table was created using parallel slaves. The last time I had such issue was with 9.2.0.4 (or 3) when PX and hash joins broke when used together, when I disabled any one of them, everything worked fine.

If disabling parallelism doesn't help then I'd set optimizer_features_enabled to lower value and tried again.

And of course there's this Oracle's unbreakable site called metalink. As you're on 10.2 and can produce a test case, you should get this bug fixed alright..

Tanel.

• Original Message ----- From: "Ian Cary (C)" <Ian.Cary_at_ordnancesurvey.co.uk> To: <stellr_at_cns.vt.edu>; "oracle-l" <oracle-l_at_freelists.org> Sent: Wednesday, May 24, 2006 9:03 PM Subject: Scary 10gR2 query problem

>
> As there seem to a few people using 10.2 (10.2.0.2 on Solaris 9 in my
> case) I thought I'd share a scary issue with you all.
>
> Odd in the example below is a reasonably complex view that has been
> working fine in 10.1 for quite a while.
>
> MP409SH2> select count(*) from odd;
>
> COUNT(*)
> ----------------
> 67311
>
> Elapsed: 00:01:15.56
> MP409SH2> create table very_odd as select * from odd;
>
> Table created.
>
> Elapsed: 00:07:34.00
> MP409SH2> select count(*) from very_odd;
>
> COUNT(*)
> ----------------
> 1371016
>
> Elapsed: 00:00:01.84
>
> This is a 100% genuine case where the select statement returns the wrong
> (substantially) number of rows. In 10.1 the view returns the correct
> 67311 rows.
> There doesn't seem to be any pattern or reason for the error and I only
> noticed it because I had the 10.1 results to hand.
> I'll be raising a tar as soon as Metalink sorts itself out but I thought
> I'd share this as I'm not sure I can 100% trust the results of any
> select statement on 10.2
>
> Cheers,
>
> Ian
> .
>
>
> This email is only intended for the person to whom it is addressed and may
> contain confidential information. If you have received this email in
> error, please notify the sender and delete this email which must not be
> copied, distributed or disclosed to any other person.
>
> Unless stated otherwise, the contents of this email are personal to the
> writer and do not represent the official view of Ordnance Survey. Nor can
> any contract be formed on Ordnance Survey's behalf via email. We reserve
> the right to monitor emails and attachments without prior notice.
>
> Thank you for your cooperation.
>
> Ordnance Survey
> Romsey Road
> Southampton SO16 4GU
> Tel: 023 8079 2000
> http://www.ordnancesurvey.co.uk
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l