Home » RDBMS Server » Server Utilities » data pump (11gR2 OEL6.3)
data pump [message #623124] Thu, 04 September 2014 23:04 Go to next message
smunir362
Messages: 306
Registered: September 2007
Senior Member
I have a question
expdp directory=abc dumpfile=full.dmp logfile=full.log full=y parallel=4
expdp directory=abc dumpfile=full-%U.dmp logfile=full.log full=y parallel=4

Which one is fast....
Re: data pump [message #623125 is a reply to message #623124] Thu, 04 September 2014 23:08 Go to previous messageGo to next message
BlackSwan
Messages: 26606
Registered: January 2009
Location: SoCal
Senior Member
both are the same
Re: data pump [message #623126 is a reply to message #623125] Thu, 04 September 2014 23:14 Go to previous messageGo to next message
smunir362
Messages: 306
Registered: September 2007
Senior Member
I think
4 parallel processes are writing into one dump file.........slow
4 parallel processes are writing into four dump files........fast
Re: data pump [message #623129 is a reply to message #623126] Fri, 05 September 2014 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 26606
Registered: January 2009
Location: SoCal
Senior Member
smunir362 wrote on Thu, 04 September 2014 21:14
I think
4 parallel processes are writing into one dump file.........slow
4 parallel processes are writing into four dump files........fast

If you have your answer, why do you bother us with the question?

post reproducible test case.
Re: data pump [message #623149 is a reply to message #623129] Fri, 05 September 2014 04:02 Go to previous messageGo to next message
smunir362
Messages: 306
Registered: September 2007
Senior Member
I was not confirmed...
It is my thinking...may be wrong
So please answer....
Re: data pump [message #623166 is a reply to message #623149] Fri, 05 September 2014 07:45 Go to previous messageGo to next message
EdStevens
Messages: 1124
Registered: September 2013
Senior Member
smunir362 wrote on Fri, 05 September 2014 04:02
I was not confirmed...
It is my thinking...may be wrong
So please answer....


What do your own tests indicate about the behavior in your own systems?
Re: data pump [message #623185 is a reply to message #623166] Fri, 05 September 2014 10:37 Go to previous message
smunir362
Messages: 306
Registered: September 2007
Senior Member
ok
I will post it soon
Previous Topic: EXPORT DUMP File max size.
Next Topic: ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD
Goto Forum:
  


Current Time: Thu Oct 17 15:48:22 CDT 2019