on 06-07-2008 11:48 PM
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...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.