Re: expdp slowness issue on oracle 10g with sun solaris
From: laurent leturgez <leturgezl_at_gmail.com>
Date: Thu, 9 Jan 2014 10:09:26 +0100
Message-ID: <CAHcMOrBpwG=wcSe8nRRBPBQdLdUDzvvy-PFva045rx6sM=DYzg_at_mail.gmail.com>
Hello
Date: Thu, 9 Jan 2014 10:09:26 +0100
Message-ID: <CAHcMOrBpwG=wcSe8nRRBPBQdLdUDzvvy-PFva045rx6sM=DYzg_at_mail.gmail.com>
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-lReceived on Thu Jan 09 2014 - 10:09:26 CET