Data Pump (expdp/impdp) Tuning features - PARALLEL option for faster performance behavior



The Eucharistic Miracles of the World
Some Facts about DATA PUMP Parallel=n option
  • By default the value of the parallel option is 1
  • Export job creates those many threads specified in the parallel option.
  • The value of the parallel option can be modified in interactive mode.
  • This option used with %U clause in the filename parameter of the expdp/impdp
  • Resource consumption can be controlled using the parallel option. PARALLEL is the only tuning parameter that is specific to the Data Pump
  • It is recommended that the value of the parameter should not be more than 2 times of number of CPUs in the database server for the optimum performance
  • Example : expdp trans/trans SCHEMAS=trans DIRECTORY=exportdir DUMPFILE=exptrans%U.dmp PARALLEL=3
Syntax to import above dump file: imppdp trans/trans DIRECTORY=exportdir DUMPFILE=exptrans%U.dmp PARALLEL=3
  • In transportable tablespace export, the degree of parallelism cannot be greater than 1.
  • If a substitution variable (%U) were specified along with the PARALLEL parameter, then one file for each template is initially created. More files are created from the templates as they are needed based on how much data is being exported and how many parallel processes are given work to perform during the job.
  • During import (impdp) the PARALLEL parameter value should not be larger than the number of files in the dumpset


Website Stats


Vipin on 1 June 2011 at 10:07 said...

Shony atta.Vipin here.The blog seems to be very efficient. Can you please include CDC( Change Data Capture) topic.

Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer