Re: DP export 5x slower in 11.2 than 10.1

From: Rich Jesse <>
Date: Tue, 14 Aug 2012 09:36:16 -0500 (CDT)
Message-ID: <>

I wrote:

>> This concerns me because I have another DP job that runs over a DB link
>> that
>> pulls data instead of metadata and orders of magnitude more of it. I'm
>> wondering now if it'll take 15 hours instead of 3 for that.
>> I'd check MOS, but it's in an unscheduled outage right now.

From my SR, there is a new MOS article "Datapump Performance for Export Slow In compared to [ID 1467205.1]", which states:

The bug 13741355 is closed as not feasible to fix but will be fixed in a future release which has not yet been announced.

_at_ We have exhausted everything we can think of to improve the performance of
_at_ unloading large numbers of package bodies and have not managed to increase
_at_ the performance in any significant way. Sadly we are going to have to defer
_at_ this until a later release where we can totally redesign the method of
_at_ retrieving large amounts of data from source$ (especially on these slower
_at_ processors).

Wow. I wonder if my 4-hour DP job will now take 20 hours.

I can hardly wait to see what severe flaw exists in the version of Oracle that fixes this particular pile of happiness.


Received on Tue Aug 14 2012 - 09:36:16 CDT

Original text of this message