Re: 10g data pump question
From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Thu, 20 Nov 2008 15:31:20 -0800 (PST)
Message-ID: <61669cfc-6e07-45a9-8ca3-1bb035cd6052@k36g2000yqe.googlegroups.com>
Date: Thu, 20 Nov 2008 15:31:20 -0800 (PST)
Message-ID: <61669cfc-6e07-45a9-8ca3-1bb035cd6052@k36g2000yqe.googlegroups.com>
On Nov 20, 11:24 am, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
> Why is it that when I run a data pump operation with PARALLEL > 1, I
> only ever see one worker EXECUTING and the state for all the others is
> WORK WAITING? What would cause that?
>
> TIA
The parallel seems to only operate doing the table loads many of the
other parts ( building indexes etc ) seem to be single threaded.
Here's one that ran today 11g <==> 11g on a quad core xeon that just rocked ... ( at least in the table loading part ).
export ORACLE_SID=dev
impdp schemas=my_schema_name parallel=4 network_link=prod
directory=EXPORTS logfile=impdp_my_schema_name_from_prod.log << EOF2
**********/************
EOF2
Received on Thu Nov 20 2008 - 17:31:20 CST