Re: 10g data pump question

From: hpuxrac <>
Date: Thu, 20 Nov 2008 15:31:20 -0800 (PST)
Message-ID: <>

On Nov 20, 11:24 am, Chuck <> 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?
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

Original text of this message