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


 

HTML Text

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.

 

 Ēcall

††
 

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.