Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle datapump setting up parallel option

supersenJul 15 2016 — edited Jul 16 2016

Hello

Could you please guide me in setting up values for parallel option during expdp( Export)

Oracle version: 11.2.0.4.0

Initially I set parallel =10 and it is working fine for small dbs's with 20GB size. But when I go for export big db (450GB) it sucks.

Expdp is very slow and processing table by table and it is very slow.

How to calculate the value for parallel.

Document says "For maximum throughput, do not set PARALLEL to much more than twice the number of CPUs (two workers for each CPU)."

How to calculate CPU count in AIX SERVER?

lparstat -i | grep CPU

Online Virtual CPUs : 15

Maximum Virtual CPUs : 20

Minimum Virtual CPUs : 14

Maximum Physical CPUs in system : 32

Active Physical CPUs in system : 32

Active CPUs in Pool : -

Shared Physical CPUs in system : 0

Physical CPU Percentage : 100.00%

Desired Virtual CPUs : 1

Please advise

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2016

Added on Jul 15 2016

#database-key-features, #export-import-sql-loader-external-tables

13 comments

7,702 views