RE: Question on Datapump parallel value
Date: Tue, 21 Oct 2008 19:42:07 +0300
I'm not aware of a feature in Grid that enables you to copy data in parallel for Streams.
However, you still can accomplish this by configuring Streams manually. We have done this for our Streams site where import was done in parallel.
If interested in how, let me know
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Anurag Verma
Sent: Tuesday, October 21, 2008 2:21 AM
Subject: Question on Datapump parallel value
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...
-- Anurag Verma, Database Administrator ERCOT(Electric Reliability Council of Texas), Texas 76574 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 21 2008 - 11:42:07 CDT