Before using the parameter we must know about the parameter:-
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
- 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