Datapump Export always runs in Parallel (Doc ID 2894075.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

Oracle datapump applies by default degree=8

- no parallel clause in the expdp command
- no %U in the dumpfile parameter
- no DOP in the exported table nor one of its indexes.

Changes

 -- Parallel degree limit is set in Resource manager

dbms_resource_manager.create_plan_directive (
      plan => 'LIMIT_EXEC_TIME'
     ,group_or_subplan => 'GROUP_WITH_LIMITED_EXEC_TIME'
     ,switch_group => 'CANCEL_SQL'
     ,switch_time => 240
     ,switch_estimate => FALSE
     ,switch_for_call => FALSE
     , parallel_degree_limit_p1 => 8
     ,comment => 'Kill statement after exceeding total execution time'  );

-- Now any export executed runs with minimum DOP 8
expdp full=Y directory=DIR_PAR_8 dumpfile=PAR_8.dmp logfile=expdp_PAR_8.log TRACE=1ff0300

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.