OraFAQ Forum: Server Utilities » Improve expdp performance

Home » RDBMS Server » Server Utilities » Improve expdp performance (10.2.0.4, Sun Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Improve expdp performance [message #543418]

Tue, 14 February 2012 11:57

lg123
Messages: 225
Registered: August 2008

Senior Member

I am using expdp to export some tables, which is taking long time to complete. I use the following parameters :

DUMPFILE, SCHEMAS, INCLUDE, DIRECTORY, PARALLEL, LOGFILE, STATUS

Can someone suggest any method so that the expdp can complete faster?

Report message to a moderator

Re: Improve expdp performance [message #543419 is a reply to message #543418]

Tue, 14 February 2012 11:59

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

export smaller or fewer tables

You can't push a string.

[Updated on: Tue, 14 February 2012 11:59]

Report message to a moderator

Re: Improve expdp performance [message #543426 is a reply to message #543419]

Tue, 14 February 2012 12:20

Flyby
Messages: 188
Registered: March 2011
Location: Belgium

Senior Member

If oracle 11 and Enterprise Edition and advanced compression, compression might help

[Updated on: Tue, 14 February 2012 12:25]

Report message to a moderator

Re: Improve expdp performance [message #543430 is a reply to message #543418]

Tue, 14 February 2012 12:40

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Buy faster disks and more powerfull cpus.
Remove all users.

Regards
Michel

Report message to a moderator

Re: Improve expdp performance [message #543580 is a reply to message #543430]

Wed, 15 February 2012 07:37

lg123
Messages: 225
Registered: August 2008

Senior Member

Before it took almost 10 hours to export using datapump of around 500 GB and 2 months later, it took 24 hours to take export of 690 GB.

I checked the number of cpu's by looking at the cpu_count and the value is 12. The parallel option is set to 9. Please suggest any method so that it takes considerably less time to complete?

Report message to a moderator

Re: Improve expdp performance [message #543582 is a reply to message #543580]

Wed, 15 February 2012 07:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you investigate where time is spent?
Have you recorded cpu and io consumption?
If you don't where time is spent and which resource is blocking you cannot improve the performances (and this is true for all performances problem).

Regards
Michel

Report message to a moderator

Re: Improve expdp performance [message #543741 is a reply to message #543580]

Thu, 16 February 2012 11:05

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Why are you exporting 690Gb worth data? What is the need?

[Updated on: Thu, 16 February 2012 11:05]

Report message to a moderator

Previous Topic:	exclude clause related
Next Topic:	exp and impdp

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 17:05:14 CST 2025