Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Conclusion

This chapter covered a lot of different topics.  From installing and upgrading the database to Oracle internals and memory structures.   The key points to remember from this chapter are:

• Follow the upgrade and installation guides like a cookbook. You should only deviate from them when it is absolutely required.
   

• The UNIX and LINUX environments require some additional kernel parameter settings (semaphores and shared memory segments) that although often overlooked, are critical to a trouble-free Oracle database environment.
   

• Use the ORADIM utility to create the Oracle Windows service, which is required on all Windows platforms.
   

• Oracle9i provides administrators with a new parameter file, called the SPFILE that allows the database to be configured dynamically.  Changes made in the SPFILE are also persistent which means the changes remain in effect after the database has been recycled.

• Never, ever edit the SPFILE.
   

• As I tell all of my entry-level classes “memory FAST, disk SLOW”.  Start your database tuning process by looking at the hit ratios for the shared pool and database buffer cache.

Our next chapter will cover Oracle database objects. The chapter begins by providing information database objects (control files, redo logs, tablespaces, datafiles. rollback segments) and finishes with a discussion on Oracle tables and indexes.
 

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot.