O'Reilly logo

Oracle Database 12c Backup and Recovery Survival Guide by Aman Sharma, Francisco Munoz Alvarez

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required