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.