Re: move database from sparc to linux
Date: Tue, 22 Jun 2010 23:30:14 +1000
Message-ID: <4C20BAE6.2070101_at_yahoo.com.au>
joel garry wrote,on my timestamp of 22/06/2010 3:09 AM:
>> That must be indeed a very slooooow Solaris sparc system! >> I regularly export 100GB with expdp in AIX in much less than 2 hours. >> Admittedly: a lot less than 400k db objects. Around 75K.
>
> See http://www.orafaq.com/usenet/comp.databases.oracle.server/2006/11/15/0883.htm
>
> expdp springs memory leaks (see bug 5095025 for too little
> information), and Solaris just generally seems to have idiosyncratic
> performance issues, which I say based on the posts I've seen in
> various places, my personal knowledge of it is way old, but it was
> true then, too.
Yikes! And this is now Oracle's own OS... I'm truly glad we decided to ditch all Solaris stuff a few years ago and gone all AIX/Looneeks! Long before it all became Oracle.
> For me, 50G (export size) direct path exp takes 45 minutes, full rman
> about an hour on hp-ux, low end san.
Ball park what I get as well with AIX, 10.2.0.3 patched to the ears.
> Some people have complained about LOB and domain indexes expdp
> performance.
Haven't had a problem. In fact if anything, I'm impressed with datapump's
performance and capability in AIX! Use it all the time now, instead of good ole
exp/imp.
The only problem so far was a glitch that stopped sub-partitioned tables from
being imported in both data mode and transportable ts mode. Quickly fixed by
application of a patch that changed the XML skeleton used by the datapump mechanism.
Received on Tue Jun 22 2010 - 08:30:14 CDT