Re: external table parallel issue
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 16 May 2010 18:26:55 +0200
Hi
The size varies from a few MB to a couple hundreds of MB.
With 1 external table the query is pretty fast, we have other process which
run against only a single external tables larger than the problematic one
and the timing is much better.
The problem with this I am showing is that it is formed by many external
tables and to simply the query we created several union all views on top of
these external tables. I will test without views and see what happens.
TIA
On Sun, May 16, 2010 at 5:05 PM, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx> wrote:
> Two questions:
> - How big are the file sizes in MB?
> - Can you reproduce this behavior with only 1 external table?
>
> On Sun, May 16, 2010 at 1:51 AM, LS Cheng <exriscer@xxxxxxxxx> wrote:
> > The parallel degree is 8, 10.2.0.4.2 RAC, the plan is huge so I am
> attaching
> > a file (look for word Parallel Slave), I only included 3 PQ plans but
> there
> > are around 16 but from PQ 2 the plans is all the same for the rest so the
> > relevant are 3 I am attaching
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
Other related posts:
