My Oracle Support Banner

Datapump Export always runs in Parallel (Doc ID 2894075.1)

Last updated on SEPTEMBER 16, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 19.8.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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