Question:
What is the optimal degree of parallelism
for the Oracle data pump export utility? The
expdp
command has a parallel argument, and I need to run it in
parallel.
Answer: As a
general rule for processes you find the cpu_count
parameter (v$parameter) and use cpu-count-1. However.
the Oracle Utilities documentation makes a slightly
different recommendation for using a Data Pump export
Set the degree of parallelism to two times
the number of CPUs, then tune from there.
Oracle Corporation specifies these rules of thumb for
setting the optimal degree of parallelism. Also see
these notes on creating
Data Pump
expdp multiple dmp files