Re: DP export 5x slower in 11.2 than 10.1
From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Tue, 14 Aug 2012 09:36:16 -0500 (CDT)
Message-ID: <b382e9646b2482b4ac626ed2eb5a775f.squirrel_at_society.servebeer.com>
I wrote:
Date: Tue, 14 Aug 2012 09:36:16 -0500 (CDT)
Message-ID: <b382e9646b2482b4ac626ed2eb5a775f.squirrel_at_society.servebeer.com>
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 11.2.0.2 compared to 10.2.0.4 [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.
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 14 2012 - 09:36:16 CDT