Re: expdp very sllllllllloooooooooowwwww
Date: Sun, 23 Nov 2008 12:23:48 -0800 (PST)
On Nov 23, 7:12 am, dk <kigh..._at_bellsouth.net> wrote:
> >> I have a database with quite a few partition tables. Each of the tables
> >> has 751 partitions. In addition the tables have about 30millions rows
> >> each.
> >> Why would expdp be so slow it looks like i†'s not moving(status command).
> >> I use the parallel option.
> >> I've opened a SR with oracle suppor† - no luck.
> >> ANy ideas would be greatly appreciated!
> > What patch level are you on? This can be a potential bug.
> I believe I've found the answer. The analyze job has been failing.
> Once I re-analyzed the db - the expdp took about 2 hours to complete.
Thanks for the update ( more than a lot of people asking questions do unfortunately ) and glad you are back in operation. Received on Sun Nov 23 2008 - 14:23:48 CST