expdp slowness issue on oracle 10g with sun solaris
From: krishna moorthy <krishnamoorthykc_at_gmail.com>
Date: Thu, 9 Jan 2014 14:31:23 +0530
Message-ID: <CAE_3N3un6U71WjqFk6p7WyKrf7dDXk7UjuAuwpy-29-9_6mvTA_at_mail.gmail.com>
Hi,
Date: Thu, 9 Jan 2014 14:31:23 +0530
Message-ID: <CAE_3N3un6U71WjqFk6p7WyKrf7dDXk7UjuAuwpy-29-9_6mvTA_at_mail.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:01:23 CET