Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle




Donald K. Burleson

Oracle Tips  

Migration to Oracle

Preparing to Migrate

Invariably, other “experts” (using the term loosely) and I will be asked hundreds of questions about installation and migration to Oracle that could have been answered if the people asking the questions had read the documentation and tested new features before implementation. The point is, you have to take the time to study the new features sections of the manuals, read the readme.doc, and review utility scripts for “hidden” changes.

Back when the Oracle8 migration was the rage, I mentioned the compatible parameter in one of my columns. A couple of weeks later, Oracle announced a spate of bugs that related to the parameter. Were the two related? Probably. It demonstrated that people who thought they had “migrated” to a new version of Oracle hadn’t. Why? Because of the setting of the parameter, they hadn’t even tested the new features that depended on a new redo log format! Reading the documentation before they migrated would have prevented this.

How about the person who buys one of those great new sport utility vehicles only to discover it won’t fit in their garage? Obviously, they didn’t check available resources before “migrating” to a new vehicle. Oracle will take up to 150 percent more space for initial load than Oracle8 and up to three times the space of Oracle 7.3. Do you have enough free space? You may want to run both an Oracle and an Oracle8i (or earlier release) system in parallel. Do you have enough memory (9i may require twice to three times as much memory as previous releases (512 megabytes on Linux, for example) or enough CPU? You will require at least 50 meg of free space in an 8i SYSTEM tablespace to upgrade to 9i, or the upgrade will fail. You may also want to take note that the default installation of an Oracle database contains a SYSTEM tablespace that is near 350 megabytes in size with only 40 Kilobytes free, you should plan your sizing accordingly.

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.




Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.