external table parallel issue

From: LS Cheng <exriscer_at_gmail.com>
Date: Sat, 15 May 2010 14:52:12 +0200
Message-ID: <AANLkTikRD1glPQVyuPscLbCHhsWay0MjGfZgkArjRJ_B_at_mail.gmail.com>



Hi

I have a query which runs against 64 external tables, the query uses union all to return the results.

The query is really slow even with high parallel degree and I noticed that it is because in the 64 external tables most of times the last 50 tables hasnt got any rows so when the parallel coordinator assigns slaves many times the first two slaves reads the 14 tables with most of data and the rest reads the empty tables. Due to this even I use parallel the query is pretty slow.

Anyone got experience how to deal with this?

Thanks

--
http://www.freelists.org/webpage/oracle-l
Received on Sat May 15 2010 - 07:52:12 CDT

Original text of this message