Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dpexp is still slower than it should be....

User_UOVAAMay 30 2013 — edited May 30 2013
Ref. my earlier posting: 11044724
Oracle EE 11.2.0.2 on Solaris 10

Since then, I'm exporting to a locally mounted file system, and the write time to the local filesystem is much much faster than to the NFS mounted filesystem.
Actually, I haven't resolved why the NFS filesystem is so slow, but that's another issue.
Depending on the server I am writing to the NFS filesystem, it is either .4 seconds to write 10M, or 32 seconds from this server to the same NFS mount.

Anyway, moving on....

My write time to the locally mounted filesystem is .1 second.
$ time dd if=/dev/zero of=/opt/oracle/orabackup/mydb/iotest.jww count=20480
20480+0 records in
20480+0 records out

real    0m0.10s     <====
user    0m0.01s
sys     0m0.07s
But, now that I am writing my export to the faster locally mounted filesystem, my export is still taking much longer than I would expect.
I started the export of 235G over 2 hours ago and it isn't even half done yet.
I'm using parallel=4 because we still have two production databases on this server and I do not want to impact them.
What else can I do to increase the speed of my export.

My export script with parameters is as follows:
${ORACLE_HOME}/bin/expdp  \'/ as sysdba\'        \
FULL=Y                                           \
directory=${ORACLE_SID}                          \
dumpfile=expdp_${ORACLE_SID}_FULL_${DATE}_%U.dmp \
logfile=expdp_${ORACLE_SID}_FULL_${DATE}.log     \
JOB_NAME=expdp_full_${DATE}                      \
PARALLEL=4                                       \
COMPRESSION=ALL                                  \
FILESIZE=30G
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 27 2013
Added on May 30 2013
12 comments
1,091 views