Re: DP export 5x slower in 11.2 than 10.1
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Tue, 31 Jul 2012 14:34:16 -0700
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@xxxxxxxxxxxxxxxxxxxxx> 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>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
