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?
|
|
|
|
|
|
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?
|
|
|
|
|