How to increase expdp/impdp performance using Parallel parameter

Before using the parameter we must know about the parameter:-
  • 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 is used with %U clause in the filename parameter of the expdp/impdp.
  • 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.
  • In transportable tablespace export, the degree of parallelism cannot be greater than 1.
  • During import (impdp) the PARALLEL parameter value should not be larger than the number of files in the dumpset

sample example:-
expdp username/password directory=dump_dir filesize=1G dumpfile=full%U.dmp logfile=fulllog.log parallel=2 exclude=statistics

impdp username/password directory=dump_dir dumpfile=full%U.dmp logfile=full.log parallel=2

To get your server's no of cpu core:-

#lscpu
root@server1 dpdump]# lscpu
Architecture:          x86_64
CPU op-mode(s):        32-bit, 64-bit
Byte Order:            Little Endian
CPU(s):                1
On-line CPU(s) list:   0
Thread(s) per core:    1
Core(s) per socket:    1
Socket(s):             1
NUMA node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 42
Stepping:              7
CPU MHz:               3292.549
BogoMIPS:              6585.09
Hypervisor vendor:     VMware
Virtualization type:   full
L1d cache:             32K
L1i cache:             32K
L2 cache:              256K
L3 cache:              6144K
NUMA node0 CPU(s):     0

No comments:

Post a Comment