Datapump Parallel Throttling

All posts relating to Oracle database administration.

Moderator: Tim...

Posts: 401
Joined: Wed May 04, 2011 3:14 pm

Datapump Parallel Throttling

Postby jnrpeardba » Mon Apr 14, 2014 1:25 pm

Hi Tim,

I wonder if you can help.

I have a large dataset which requires exporting over a number of days. I deally I would like to start the export off
running with 8-12 parall workers and then while the same export is executing, drop this down to 1-2 during the
week, when users are using other databases on the same server..

I read someone that this is feasible, but wondered if you could clarify

many thanks


Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: Datapump Parallel Throttling

Postby Tim... » Mon Apr 14, 2014 5:18 pm


Can't say I've ever tried, but it supposedly possible.

When you are running your DP job, you CTRL+C on it to switch to the command mode. You should then be able to use "PARALLEL 2" to switch the DOP. I'm assuming it finishes the current file before it reduces the DOP.

Like I said, not tried this myself, so I can't report on it. I suggest you give it a go first. :)


Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website:
My blog:

Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 2 guests