Solved

Datapump How to improve import speed

Posted on 2009-05-06
4
598 Views
Last Modified: 2013-12-18
Hi guys,

I'm struggling to imporve datapump import speed (local, not via network or dblink), doing no benefit, have tried these options:
parallel = 1 -> 3 hrs & 42 mins   (no parallel is better)
parallel = 4 -> 3 hrs & 51 mins
parallel = 8 -> 4 hrs & 6 mins

have 4 cpus, linux 64 bit, Oracle 10.2.0.3.

Highly appreciate, you expert/experienced thoughts.
Thanks,
EL
0
Comment
Question by:el123
  • 2
  • 2
4 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 24317028


Try:
EXCLUDE=INDEX  
 And build the indexes afterward.
 
0
 

Author Comment

by:el123
ID: 24317684
any other thoughts ?
0
 

Author Comment

by:el123
ID: 24355716
thanks MikeOM_DBA,

but need some quick/fast way to extract the index creation script, would like to add PARALLE=4 OR 6 to them and then execute those index creation script ... because got to create those indexes too.

thanks.
EL
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 24357527

INCLUDE=INDEX    
CONTENT=METADATA_ONLY
 
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
Via a live example, show how to take different types of Oracle backups using RMAN.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question