Re: DP export 5x slower in 11.2 than 10.1
- From: Tim Gorman <tim@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 31 Jul 2012 11:55:22 -0600
Rich,
What does "tkprof /<trc-file> <output-file>/sort=prsela,exeela,fchela"
say after you SQL trace the DP session?
To enable SQL tracing, you could (temporarily) use an AFTER LOGON
trigger like the one found online at
"http://www.EvDBT.com/tools.htm#tracetrg";. Be aware that this script
creates the trigger disabled, so you'll want to enable it just before
you start the EXPDP job and probably disable it right after you know it
is running.
Hope this helps...
Thanks!
-Tim
On 7/31/2012 10:53 AM, Rich Jesse 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
