Oracle Database 12c Backup and Recovery Survival Guide

Some performance tuning tips

I would like to finish this chapter talking very briefly about how you can improve the performance of your export and import operations. My recommendations are:

• Always exclude statistics:
  • Exporting and importing statistics were very slow since the introduction of Data Pump (10.1)
  • Exclude from export when possible or if included in the export; exclude them in the import operation
  • Regenerate the statistics after the import operation is completed
• Use Parallelism (requires Enterprise Edition and extra license for this option):
  • Use as many resources available to improve Data Pump performance when loading or unloading data
  • Remember it can be changed dynamically any time you need using the interactive-command mode; make parallel ...