User Guide

11.0
- 10.0

Back Next

Configuring Parallel Processing for Direct Path Unload Jobs

When cloning large amounts of data with the direct path unload method, you can improve performance by configuring parallel processing on multiple threads.

With the direct path unload method, Fast Clone uses two threads per core or CPU to unload data from an Oracle source. If the source system has multiple CPUs, Fast Clone can use parallel processing to unload data from source tables.

Click the

Runtime Settings

tab >

Parallel Execution

view.

The following image shows this view:

Enter information in the following fields:

Threads number: The maximum number of tables or partitions from which data can be unloaded in parallel. The default value is 1.
Threads per segment: The maximum number of threads that can be used to unload data from a single table or partition. If you use multiple threads for a single table, CPU usage might increase. Usually, multiple threads are used to unload large tables. The default value is 1.

To get the total number of unload threads, multiply these field values. For the direct path unload method, calculate the appropriate number of concurrent threads as follows:

number of CPUs or cores x 2

I/O

bandwidth or the number of allocated CPUs is restricted, enter lower field values that are compatible with the appropriate concurrency for the system.

If you need to unload data from many tables of similar size, set

Threads number

to the appropriate concurrency and set

Threads per segment

to 1.

If you need to unload data from a few large tables, increase the

Threads per segment

value and set

Threads number

to the number that you calculate as follows:

(number of CPUs or cores x 2)÷ number of threads per table

Rename Saved Search

Table of Contents

User Guide

User Guide

Configuring Parallel Processing for Direct Path Unload Jobs

Configuring Parallel Processing for Direct Path Unload Jobs