ORACLE Database migration to MAXDB for ECC 6.0

[former_member240396]

Hi Experts,

I have been in process of testing database migration from oracle to MAXDB(SAPDB). I have exported database of size 900GB by using package and table level splitting method in 12 hr.

Now I am importing into MAXDB. But the import is running very slow.

System is configured with 8CPU. Cache size for DB instance is allocated with 10GB. I have running R3load process with parallel 16 CPU processes. Still import is going slowly with more that 32 hrs.

So cloud some on suggest for performance improvement of this import process.

Please let me know for further information.

Regards

Santosh

[former_member240396]

Answered

[lbreddemann]

HI there!

7.6.03 ? Why do you use outdated software for your migration.

At least use 7.6.06 or 7.7.07 !

About the performance topic - well, you've to figure out what the database is waiting for.

Activate time measurement, activate the DBanalyzer with a short snapshot interval (say 120 or 60 seconds) and check what warnings you get.

Also you should use the parameter check to make sure that you don't run into any setup-induced bottlenecks.

Apart from these very basic prerequisites for the analysis of this issue, you may want to check

SAP Note 1464560 FAQ: R3load on MaxDB

Maybe you can use some of the performance features available in the current R3load versions.

regards,

Lars

p.s.

open a support message if you're not able to do the performance analysis yourself.

[Former Member]

Whats your MAXDB version and build?

[former_member240396]

Hi,

MAXDB version is 7.6.03.09

Santosh