exp vs expdp [message #271208] |
Sun, 30 September 2007 19:23 |
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 #271219 is a reply to message #271218] |
Sun, 30 September 2007 21:59 |
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 #271222 is a reply to message #271220] |
Sun, 30 September 2007 22:46 |
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 #278493 is a reply to message #271208] |
Sun, 04 November 2007 14:08 |
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.
|
|
|