[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Import a 8i database into 11g is extremely slow

Posted on 2010-04-03
9
Medium Priority
?
909 Views
Last Modified: 2012-08-14
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?
0
Comment
Question by:PaperTiger
  • 5
  • 4
9 Comments
 
LVL 81

Expert Comment

by:arnold
ID: 29623979
schema changes. structure/data updates.
http://www.dba-oracle.com/t_upgrade_migrate_8i_10g.htm
0
 
LVL 8

Author Comment

by:PaperTiger
ID: 29624792
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
 
LVL 81

Expert Comment

by:arnold
ID: 29626154
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LVL 8

Author Comment

by:PaperTiger
ID: 29627252
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
 
LVL 8

Author Comment

by:PaperTiger
ID: 29627520
Don't know how to do this "Check the oracle logs to see whether it paused awaiting resource availability" either. :-(
0
 
LVL 81

Expert Comment

by:arnold
ID: 29633140
0
 
LVL 8

Author Comment

by:PaperTiger
ID: 29699013
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
 
LVL 81

Expert Comment

by:arnold
ID: 29733084
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
 
LVL 8

Accepted Solution

by:
PaperTiger earned 0 total points
ID: 29853577
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

612 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question