cancel
Showing results for 
Search instead for 
Did you mean: 

Database Migration: Performance Optimization

Former Member
0 Kudos

Hello,

We are working on the Database Migration Project - Informix 7 to Oracle 9...

I would like to know the Optimization Parameter/ Process for the Export / Import Process...

Kindly Suggest...

Thanks & Regards,

RaHuL...

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

The parameters are depending on the number of CPUs and the speed of the underlying I/O system. I would not use more than 2 R3load per CPU.

Markus

Former Member
0 Kudos

Hi,

Thanks for the reply...

We are in Export Stage in DB Migration Project [ Informix - Oracle]...

Our Database is around 750 GB...

We are using the Splitter...

In the Export Stage the two cluster table PCL2 & PCL4 tables are taking lot of time in the process...

We have splitted the export in 37 process..35 processes got over in around 10-12 hours but the last two process of PCL2 & PCL4 tables took around 80 hours last time.. What could be the reason..

[Is data deletion from PCL2 & PCL4 feasible. What are the pros and cons for it]

Any suggestions on reducing the run time of the export...

Also i would like to know if there are any suggestions to reduce import run time also...

Thanks,

RaHuL...

markus_doehr2
Active Contributor
0 Kudos

> Is data deletion from PCL2 & PCL4 feasible. What are the pros and cons for it

I wouldn't delete the entries but archive them in case you need them later.

Markus

Answers (0)