Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Best Practises/parameters for speeding Datapump & exporting to Multiple directories

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

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Wed, 24 Jan 2007 22:15:48 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF3020027683FF@BLRKECMSG11.ad.infosys.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 24 2007 - 10:45:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US