Re: expdp very sllllllllloooooooooowwwww

On Nov 23, 7:12 am, dk <kigh..._at_bellsouth.net> wrote:

snip

> >> 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

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