Use
You can perform parallel export and import in SAPDBA for Oracle to speed up processing.
Prerequisites
The
exp_imp_degree parameter determines the degree of parallelism for the export or import. The default value for this parameter is 1.Parallel export and import is only relevant if you are:
Integration
If you are using the
export/import reorganization method to reorganize more than one table or index, you can perform parallel export and import. For more information, see Performing Processes in Parallel to Speed Up Reorganization.Features
Sequential Export and Import with exp_imp_degree = 1
If you do not change the default value for
exp_imp_degree , all export and import processes are executed sequentially. SAPDBA suggests the <timestamp> directory created in <SAPDATA_HOME>/sapreorg as the target for the export dump files. For more information, see the exireo_dumpdir parameter.Parallel Export and Import with exp_imp_degree > 1
If several export dump files are to be created, then the export or import can be executed in parallel if you:
Parallel Processing
SAPDBA generates one export dump file for each parallel process, distributing the tables to the individual export dump files on the basis of their size, to ensure that the files all have approximately the same size. However, SAPDBA also takes the size of the file systems or tapes into account.
SAPDBA assigns parallel processes as follows:
You can compress the export dump files in all the directories on disk while using parallel processing. However, the compress option has no effect when exporting to tape, for which you must use hardware compression instead.
See also: