Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export Data Pump Performance

Posted on 2014-11-26
1
Medium Priority
?
252 Views
Last Modified: 2014-11-28
Hi expert,
I have to run export data pump on a production Oracle DB, I'd like to know what happen when I run this data pump export and if it produces negative effects on the DB performance.

Thanks in advance!
0
Comment
Question by:ralph_rea
1 Comment
 
LVL 14

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 2000 total points
ID: 40466637
In general: yes. Depending on the your setup, the amount of data, the Data Pump config and so on, it might have a more or less "great" impact on the overall performance of your system.
With no other input/information, this question is quite vague to me...

Here are some links which could be of interest:
http://stackoverflow.com/questions/16788264/will-oracle-data-pump-affect-performance

http://docs.oracle.com/cd/B28359_01/server.111/b28319/dp_perf.htm#g1008057

http://www.dba-oracle.com/t_data_pump_export_performance_tuning.htm

http://infodba.wordpress.com/2010/08/11/checklist-for-slow-performance-of-export-data-pump-expdp-and-import-datapump-impdp-id-453895-1/
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question