DP export 5x slower in 11.2 than 10.1
- From: "Rich Jesse" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>
- To: "Oracle L" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 31 Jul 2012 11:53:29 -0500 (CDT)
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
Other related posts:
