Best Practises/parameters for speeding Datapump & exporting to Multiple directories

Folks  

1 more issue  

There exist 2 Target partitions each of Size 400 GB in which the respective 700 GB Table needs to be exported using Datapump.

Additionally a High Value of PARALLEL parameter is preferred to Speed up the 700 GB Export.

What Value of PARALLEL is Advisable for an 8 CPU machine connected to an EMC Storage Box?  

Are the following parameters & Syntax Advisable? If so, will it restrict the PARALLEL parameter specification to a MAX value of 2 only?  

DUMPFILE=/Partition1:Tbl_Part%U.dmp, /Partition2:Tbl_Part%U.dmp

FILESIZE=350G PARALLEL=8   Can /Partition1 & /Partition2 be explicitly Specified? I am unable to follow the meaning of the word "directory_object"

Is the Directory Object an Environment Variable which needs to be set on the O.S.?  

Cheers  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of VIVEK_SHARMA Sent: Wednesday, January 24, 2007 6:16 PM To: oracle-l_at_freelists.org
Subject: Best Practises/parameters for speeding Datapump  

Folks  

Using Datapump need to export & import a 700 GB Table having a LONG Column (containing JPEGs).  

Any Rough Estimate on Time needed for the same?  

What best practices / parameters are Advisable to speed up the same?  

Any Links will help.  

Config:-

Oracle 10gR2

Solaris 10

SunFire - 8 CPUs

RAM 32 GB   Cheers

• CAUTION - Disclaimer ***************** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l