expdp slowness issue on oracle 10g with sun solaris

  • From: krishna moorthy <krishnamoorthykc@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 9 Jan 2014 14:31:23 +0530

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

Other related posts: