DP export 5x slower in 11.2 than 10.1

From: Rich Jesse <rjoralist2_at_society.servebeer.com>
Date: Tue, 31 Jul 2012 11:53:29 -0500 (CDT)
Message-ID: <cf2f8794f887c5ca33566bcc0d6de1e6.squirrel_at_society.servebeer.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 31 2012 - 11:53:29 CDT

Original text of this message