Re: Bottleneck in 8i parallelism

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 17 Nov 1999 21:53:23 -0000
Message-ID: <942876324.27312.1.nnrp-03.9e984b29@news.demon.co.uk>

5 million rows is not very many.
Why only parallel 2 ?
What is the nature of the CTAS SQL ?
Where is the bottleneck ?
Can you supply a full execution plan.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

aozocak_at_my-deja.com wrote in message <80u8a9$oqk$1_at_nnrp1.deja.com>...
>Hi,
>
>We are implementing a datawarehouse on a 8-CPU domain of a Sun 10000. We
>have a performance bottleneck when we tried to load a 5 million entry
>table using 'create table as select'. Our large pad size is 300 MB, and
>we are submitting 2 parallel tasks.
Received on Wed Nov 17 1999 - 15:53:23 CST