Re: external table parallel issue

  • From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • To: LS Cheng <exriscer@xxxxxxxxx>
  • Date: Sun, 16 May 2010 08:05:01 -0700

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
--
//www.freelists.org/webpage/oracle-l


Other related posts: