Share

Parallel Index Creation with Data Pump Import in Oracle DB 12.1.0.2

Oracle Database Enterprise Edition Version 12.1.0.2

Problem Statement : Indexes are not picking parallel processes while execution of impdp utility




SOLUTION

Parallelism is used for loading user data, package bodies and for building indexes.

 

It was noticed that the indexes are not created in parallel, since there is only one worker process executing this task.

The parallelism in index creation is actually referring to the IO slaves that are used to create a single index

When this index is defined with a parallel degree greater than one, the creation of indexes in parallel has been addressed in the below mentioned Enhancement Request

 

 



 

 

 

Bug 5629423 – DATAPUMP DOES NOT CREATE THE INDEXES IN PARALLEL

This enhancement was implemented as a bug fix.

Please download generic patch 22273229 (available for 12.1.0.2 and 11.2.0.4).

If any further help required, please raise an Oracle SR.

This functionality will be built into future releases as well as per Oracle guidelines.

 

 



Leave A Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!