Re: external table parallel issue
- From: Rich <richa03@xxxxxxxxx>
- To: exriscer@xxxxxxxxx, Oracle Mailinglist <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 15 May 2010 08:29:31 -0700
Sql with dynamic parallel hint built by script at the OS level looking
at file sizes?
On 5/15/10, LS Cheng <exriscer@xxxxxxxxx> wrote:
> 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
>
--
Sent from Gmail for mobile | mobile.google.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
