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  

Test the Oracle Migration Process

Oracle offers a plethora of new features, including automated rollback (now called undo) segment administration, multiple block sizes in the SGA, and tablespaces, and the ability to change SGA parameters on the fly. You may be shifting to the new release to overcome bugs that were present in the previous release, or only for specific new features that arenít mentioned here.

I want to make a statement here that Iím sure will have some folks shuddering: If you are completely happy with your application, donít force fit it into these new features. Change for the sake of change is foolish. If there is a good, viable reason to implement these new features, by all means do so, but donít be a lemming and just follow the herd over the cliff. Oracle will function very well with an Oracle8i application resting inside of it. Donít feel that you must convert your applications immediately to the new features. Take some time and get familiar with the ride of the new database, and watch for its quirks before you start pell-mell into conversion.

Oracle MIG utility

No, this isnít a new Russian fighter plane. MIG is the migration utility that Oracle has provided to get your Oracle7 database into an Oracle database. Essentially, there are two main paths and a rocky third to migrate from Oracle7 to Oracle. These are:

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.