Import a 8i database into 11g is extremely slow

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?
LVL 8
PaperTigerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arnoldCommented:
schema changes. structure/data updates.
http://www.dba-oracle.com/t_upgrade_migrate_8i_10g.htm
0
PaperTigerAuthor Commented:
Don't understand. So this behavior is expected or something? Yes, I am moving from 32 bit to 64 bit. Can't find the "precautions" in the link you provided.
0
arnoldCommented:
The change in the application /os bit version is not the issue. The issue is the conversion of the database structure from 8i to 11g
Did you setup the various rman/backup process to handle the amount of processing.
Check the oracle logs to see whether it paused awaiting resource availability.
I.e. 8i is a square peg you want to fit into a round hole.
in the olden days, you had to upgrade a version at a time, i.e. to 8.x to 9.x to 10.x sequntially.
The link provides for the mechanism which presumably what you followed.

There are no precautions. import/export mechanism deals with the transition.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

PaperTigerAuthor Commented:
How do I set up "various rman/backup process to handle the amount of processing?" I just don't see anything being processed - little disk and CPU activities.
0
PaperTigerAuthor Commented:
Don't know how to do this "Check the oracle logs to see whether it paused awaiting resource availability" either. :-(
0
PaperTigerAuthor Commented:
I think I know why. Somehow my RAID speed is unbearably slow at 35MB/s. Any of my home computers runs faster than that. Will have to call IBM tomorrow.
0
arnoldCommented:
Are you using a Hardware RAID controller or is it a software based RAID?
The issue might be that your OS and your DB are on the same RAID group.
0
PaperTigerAuthor Commented:
The solution so far is to enable WRITE BACK, basically write cache, on the RAID. It made the speed to jump from 35 to 250MB/s, not that great but much better.

Now the import only takes 1.5 hours.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.