Re: expdp very sllllllllloooooooooowwwww
From: dk <kightda_at_bellsouth.net>
Date: Sun, 23 Nov 2008 07:12:19 -0500
Message-ID: <492948A3.3090000@bellsouth.net>
>> 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!
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.
Date: Sun, 23 Nov 2008 07:12:19 -0500
Message-ID: <492948A3.3090000@bellsouth.net>
Bob Jones wrote:
> "dk" <kightda_at_bellsouth.net> wrote in message > news:HQHVk.91285$XB4.49906_at_bignews9.bellsouth.net...
>> 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 Received on Sun Nov 23 2008 - 06:12:19 CST