Re: DP export 5x slower in 11.2 than 10.1

From: Greg Rahn <greg_at_structureddata.org>
Date: Tue, 31 Jul 2012 14:34:16 -0700
Message-ID: <CAGXkmivKaqrd_P-rKtOQGn4gX5qPF5kfe9X+mxaexpAjiQHNKQ_at_mail.gmail.com>

This list should make for a good starting place (when MOS is back): How can we monitor a DataPump Job's Progress? (Doc ID 455720.1) How To Diagnose And Troubleshoot Import Or Datapump Import Hung Scenarios (Doc ID 795034.1)
DataPump Export and Import Job And Attached Client Sessions (Doc ID 262557.1)
How To Use The New 11g Events++ Syntax For Easier SQL Tracing Of Datapump Operations? (Doc ID 813737.1)
Checklist for Slow Performance of Export Data Pump (expdp) and Import DataPump (impdp) (Doc ID 453895.1)
Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump (Doc ID 286496.1)

On Tue, Jul 31, 2012 at 9:53 AM, Rich Jesse < rjoralist2_at_society.servebeer.com> wrote:

> Hey all,
>
> I backup metadata for 6 schemas a few times per day in our Dev DB on AIX
> 5.3
> using DP export to a directory on disk:
>
> time expdp / \
> content=metadata_only \
> exclude=statistics,grant \
> schemas=SCH1,SCH2,SCH3,SCH4,SCH5,SCH6
>
> (non-important parameters not shown)
>
> In 10.1.0.5, this took 4 minutes. After upgrading to 11.2.0.3, it's taking
> more than 20 minutes on the same hardware/OS. The logs are very similar in
> content.
>
> 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.
>
> Thoughts anyone? My kneejerk is stats, but where? Dictionary? Schema?
>
> Rich
>
>

-- 
Regards,
Greg Rahn  |  blog <http://bit.ly/u9N0i8>  |  twitter <http://bit.ly/v733dJ>  |
 linkedin <http://linkd.in/gregrahn>


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 31 2012 - 16:34:16 CDT