Re: expdp slowness issue on oracle 10g with sun solaris

Thanks for the reply.

It is an very small database (3 GB)i am not sure this Doc ID 1354535.1, matches with my problem.

Regards
Krishna

On Thu, Jan 9, 2014 at 2:39 PM, laurent leturgez <leturgezl_at_gmail.com>wrote:

> Hello
>
> You may have a look to this note : Slow Performance of DataPump Export
> during Estimate Phase (Doc ID 1354535.1)
>
> Regards.
> Laurent
>
>
> 2014/1/9 krishna moorthy <krishnamoorthykc_at_gmail.com>
>
>> Hi,
>>
>> Expdp is slow in the following environment.
>>
>> OS:uname -a
>> SunOS 5.10 Generic_142900-01 sun4v sparc SUNW,T5140
>>
>> Oracle version:
>> 10.2.0.5
>>
>> For 200MB,it takes more than one hour.
>>
>> I observed that expdp takes some time in estimating operation..
>>
>> Used script for expdp:
>>
>> expdp test\*** \
>> DIRECTORY=dmp_dir \
>> DUMPFILE=$EXP_FILE \
>> LOGFILE=expdp.log \
>> SCHEMAS=test
>>
>>
>> But export(exp) is much faster in the same environment.Please let me know
>> is there any know behavior/issue.
>>
>> Regards
>> Krishna
>>
>>
>>
>

--
http://www.freelists.org/webpage/oracle-l