How to increase expdp/impdp performance using Parallel parameter

Before using the parameter we must know about the parameter:-

1.By default the value of the parallel option is 1
2.Export job creates those many threads specified in the parallel option.
3.The value of the parallel option can be modified in interactive mode.
4.This option is used with %U clause in the filename parameter of the expdp/impdp.
5.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.
6.In transportable tablespace export, the degree of parallelism cannot be greater than 1.
7.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

Nenhum comentário:

Postar um comentário

Related Posts Plugin for WordPress, Blogger...