Home » RDBMS Server » Performance Tuning » How to improve the performance of export job(expdp)? (Oracle10gr2, Linux.)
How to improve the performance of export job(expdp)? [message #534443] Tue, 06 December 2011 03:02 Go to next message
konkalasiva
Messages: 1
Registered: December 2011
Junior Member
Hi,

I have an issue with export(expdp).

When i exporting an user using expdp utility, the load the on the server is going up-to 5. The size of the database is 180GB. Below is the command that i use for export.

expdp sys/xxxx directory=dbpdump dumpfile=expdp_trk_backup.dmp logfile=expdp_trk_backup.log exclude=statistics schemas=trk

Can you please help me to resolve this issue!

Do i need any look into any memory parameters for this?

-
Thanks
Sivanarayana

Report message to a moderator

Re: How to improve the performance of export job(expdp)? [message #534447 is a reply to message #534443] Tue, 06 December 2011 03:44 Go to previous message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
If your server is a 10 CPU one, having a load of 5 just means your server is idle.
If your server is a 1 CPU one, this means it is overloaded on CPU.
How changing a memory parameter would change this?
Either increase the parallelism of expdp hoping they will wait on IO, or remove others activity.

Regards
Michel

Report message to a moderator

Previous Topic: How to reduce cost of my query?
Next Topic: performance problem
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 14:10:10 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.