Home » RDBMS Server » Server Utilities » exp vs expdp
exp vs expdp [message #271208] Sun, 30 September 2007 19:23 Go to next message
seethem
Messages: 41
Registered: September 2007
Member
I am running 2 -node RAC oracle 10g.
My schemas are roughly 20G in a 0.4TB database.

Can someone help me troubleshoot the following observation please?

exp of schema CEN takes 2 hrs.
expdp of schema CEN takes 6 hrs.

Why is expdp so much slower than exp?

Thanks..
Re: exp vs expdp [message #271218 is a reply to message #271208] Sun, 30 September 2007 21:38 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What is the export and data pump export commands that you invoked? Are they produce same size after finished the task?
Re: exp vs expdp [message #271219 is a reply to message #271218] Sun, 30 September 2007 21:59 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member

//Old Fashion
setup_env ()
{
HOME=/home/oracle
ORACLE_SID=NODE1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
DATEDMY=$(date +"%d%m%y")

export PATH ORACLE_BASE ORACLE_SID ORACLE_HOME DATEDMY
}

dbexp ()
{
exp CEN_USER/<password> file=/some/path/CEN_${DATEDMY}.dmp log=/some/path/CEN_${DATEDMY}.log buffer=100000 statistics=none
}

setup_env
dbexp

//DP
setup_env ()
{
HOME=/home/oracle
ORACLE_SID=NODE1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
PATH=$ORACLE_HOME/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
DATEDMY=$(date +"%d%m%y")

export PATH ORACLE_BASE ORACLE_SID ORACLE_HOME DATEDMY
}

dbexp ()
{
expdp system/<password> schemas=CEN_USER directory=DP_NODE1 parallel=4 dumpfile=CEN_${DATEDMY}_dp_%U.dmp logfile=CEN_${DATEDMY}_dp_.log
}

setup_env
dbexp

//Export Sizes
The DP file is larger.

[mod-edit] annoying colors removed.

[Updated on: Mon, 01 October 2007 08:01] by Moderator

Report message to a moderator

Re: exp vs expdp [message #271220 is a reply to message #271208] Sun, 30 September 2007 22:30 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

what is the result of these parameters?

DISK_ASYNCH_IO

DB_BLOCK_CHECKING

DB_BLOCK_CHECKSUM


PROCESSES

SESSIONS

PARALLEL_MAX_SERVERS


As well as how much time it take when you remove statistics parameter during export?
Re: exp vs expdp [message #271222 is a reply to message #271220] Sun, 30 September 2007 22:46 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member

disk_asynch_io=true
DB_BLOCK_CHECKING=false
DB_BLOCK_CHECKSUM=true
processes=1500
sessions=1655
PARALLEL_MAX_SERVERS=80

Without the statistics parameter, i am not certain. I can test that. What is the game plan/reason for that request?

[mod-edit] annoying colors removed.

[Updated on: Mon, 01 October 2007 08:01] by Moderator

Report message to a moderator

Re: exp vs expdp [message #271904 is a reply to message #271208] Wed, 03 October 2007 06:11 Go to previous messageGo to next message
seethem
Messages: 41
Registered: September 2007
Member
Have you heard that both nodes can be used to throttle the expdp?

Ultimately producing a faster export?
Re: exp vs expdp [message #278493 is a reply to message #271208] Sun, 04 November 2007 14:08 Go to previous message
seethem
Messages: 41
Registered: September 2007
Member
Hey guys,

I was able to use the DP method. It cuts down exports to more than 1/3 of the time that binary exports take. ==> Good news!

Fortunately, I have a clustered file system in play so there are export processes that are transferred to the second node.

Thanks all the same.
Previous Topic: second enclosure string not found
Next Topic: Using Client side "exp"
Goto Forum:
  


Current Time: Sat Dec 10 05:24:25 CST 2016

Total time taken to generate the page: 0.08195 seconds