How To Make IMPDP Faster Using Oracle 12c New Feture

 

12c R1 Has a New Feature to suppress the generation of redo during Data Pump import.

This feature not only suppresses the redo generation but also optimizes the IMPDP.

I am showing in the below examples importing the table NAWAZ in normal conventional method and using the new feature.

 

NORMAL CONVENTIONAL USE OF IMPDP :

In the above conventional method of Impdp took 5 minutes almost and generated the archive logs.

 

Now let us see the same expample using the 12c New feature for Impdp :- transform=disable_archive_logging:y

 

Here you can see there is an improvement in the elapsed time. This is how your impdp can be optimized in the simplest way

Similary you can try it for importing the indexes and other objects too.

 

The advantage here is the time we save, and no redo generation.

Every Environment has its own requirements. Before using this feature, make sure its gonna be ok ,if suppresing the redo generation is permissable in your environment.

Shaik Mohammed Nawaz
Author: Shaik Mohammed Nawaz

Has 9+ yrs of Experience As an Oracle DBA with high expertise in Performance Tuning. Also manages Microsoft Sql Server DB. Configured Many Data Guard environments. Can provide better solutions for the Complex DB Architecture environments. Worked for Cognizant Technology Solutions India from 2011 to 2015, Currently Based in UAE working for the Govt Client Since then. For any Queries You can reach out to Mohammed Nawaz : [email protected]

Leave a Reply

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