Import a 8i database into 11g is extremely slow
Posted on 2010-04-03
I am doing a database upgrade from 8i to 11g. The server is X3650 M2 with dual quad-core CPUs, 20GB memory, and 4 10k SAS drives in RAID 10 running Win2008 64bit.
Somehow importing the database (total size 50GB) to the 11g is extremely slow. I cannot figure out why. One would expect on this machine, it would take less than 1 hour but it took 8-9 hours. It's unreal. I would expect this to be done within 1 hour. I looked at the disk activities in Task Manager's Resource Monitor, the disk is only working at 200KB/sec and CPU at 1% most of the time.
I run a simultaneous import to 8i on a 6 year old dual CPU computer (W2K+Oracle 8i), it finished the same import in 2 hours. Granted I cannot do any direct comparison.
What could be the reason?