Parallel Export/Import 
Parallel Export/Import
The export as well as the import can be distributed to several parallel processes. This also applies to exports or import processes running during a reorganization. (Exception: Reorganization of a single table or index).
exp_imp_degree = 1
If the default value for the degree of parallelism (
exp_imp_degree =1) is not changed, all export/import processes are executed sequentially. The <timestamp> -directory created in <ORACLE_HOME>/sapreorg is proposed as the target for the export dump file(s) (if the following remains unchanged: work directory = export dump file(s) directory = directory in exireo_dumpdir).exp_imp_degree > 1
If several export dump files are being created, then the export/import can be executed in parallel (degree of parallelism no greater than the value of
exp_imp_degree ). It is possible to specify a different or further directories and/or tape devices for the export dump files (to specify the Export dump destination see SAPDBA: Export Menu). The same directories may be specified several times. SAPDBA always tries to achieve the maximum degree of parallelism.One export dump file is generated from each of the parallel processes. SAPDBA distributes 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.
If the number of parallel processes defined (by specifying directories or tape devices in Export dump destination) is greater than the number of tables that are to be exported, then only one process is used for each table. The remaining directories and tape devices are not used.
If the number of directories and tape devices specified (in Export dump destination) is greater than the maximum number of parallel processes defined in
exp_imp_degree , then as many directories and tape devices are used in parallel as necessary to achieve this degree of parallelism. As soon as one of these processes ends, the other directories and tape devices available will be used by the next process.The option Compress export dump: yes enables you to compress the export dump files in all the directories on disk. Parallel export/import is also possible when this option is used.
This option has no effect when exporting to tape; use hardware compression instead.
See also:
"Specifications in Export Dump Destination - Script Descriptions" in
SAPDBA Scripts and Files,