A sample query which returns different amounts and
count is the following.
select adjctn_date,
cycle_nbr_code,
sum(reimd_amt) totalamt,
sum(fed_ffp_amt) fedamt,
count(distinct(rcpt_id)) rcnt,
count(1)
from TEST
group by adjctn_date, cycle_nbr_code
order by adjctn_date, cycle_nbr_code;
Run a query like this many times and see if the
results are identical.
The table is a partitioned with 60 partitions.
The size of the table is around 68 GB.
We were able to reproduce it on a smaller sized table
too.
- Binley Lim <Binley.Lim_at_ird.govt.nz> wrote:
>
> Could you please give more details?
>
> Under what circumstances does this occur, bug
> numbers etc, thanks
>
> >>> joni_65_at_yahoo.com 01/24/03 11:09a.m. >>>
> We have been bitten by the parallel query return
> inconsistent results while using paritioned tables.
>
> Oracle version is 9.2.0.2 64 bit.
> OS is Sun sparc 2.8 64 bit.
>
> Those of you who use the same version may want to
> run
> queries 10 to 15 times and compare results.
>
> Oracle is working on bug fix now.
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up
> now.
> http://mailplus.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Johnson Poovathummoottil
> INET: joni_65_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Binley Lim
> INET: Binley.Lim_at_ird.govt.nz
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
>
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 24 2003 - 08:13:53 CST