RE: Question on Datapump parallel value

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <anuragdba@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 21 Oct 2008 10:01:26 -0400

Not that I've found.
 

Dick Goulet 
Senior Oracle DBA 
PAREXEL International 
978.313.3426 
 information transmitted in this communication is intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission, dissemination or
other use of, or taking of any action in reliance upon, this information
by persons or entities other than the intended recipient is prohibited.
If you received this in error, please destroy any copies, contact the
sender and delete the material from any computer.


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Anurag Verma
Sent: Monday, October 20, 2008 7:21 PM
To: ORACLE-L
Subject: Question on Datapump parallel value


Hi All,


This is a question on parallel threads on Datapump imports.

Will the 10g R2 database allow us to set a default parallel thread
number in the system level so that any datapump export or import job
will use that parallel thread value for the worker processes ?

This is for 10g Streams setup and I am setting up Streams using Grid
Control.

I am not seeing any option to customize the parallel value for the "Copy
data" functionality while I setup 10g Streams.

So I am thinking if I can set up a system wide parallel value for
Datapump (even if it is temporary during the Streams setup) so that when
the copy data function starts during the Streams setup, it will start
with higher parallel thread value and finish the copying at faster
pace...


Thanks, 
-- 

Anurag Verma,
Database Administrator
ERCOT(Electric Reliability Council of Texas),
Texas 76574

Other related posts: