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