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 higher during no-peak times and lower when on peak time

  • Never forget to use the wildcard for dump file generation (%U) when using parallelism

• Use Transportable Tablespaces or Full Transportable Export/Import (as we have seen in Chapter 3, What is New...