For Oracle support & training call (800) 766-1884
Free Oracle Tips

Home
Oracle Tips
Oracle Code Depot
Oracle Monitoring
Oracle Consulting
Oracle Training
Oracle News
Oracle Forum
Oracle Support





 

Free Oracle Tips

image

 
HTML Text

Free Oracle App Server Tips

image

 
HTML Text


Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle


 

 

 

 

Donald K. Burleson

Oracle9i RAC Tips

Architecture

Oracle9i architecture consists of either single instance or multi-instance databases. Up until now, this book has been discussing multi-instance architecture. Let us digress and put this in context with the total Oracle9i picture. Figure 4.7 shows the Oracle9i single instance architecture.

Figure 4.7: Oracle9i Structures

As you can see, the overall structure of an Oracle9i single-instance database is fairly complex. A complete Oracle9i instance consists of disk files, shared memory structures, and background processes. The shared memory area is further subdivided into numerous caches and pools that are used to transfer data, programs, and instructions from processes to and from the disks and users. Let's start our examination of the Oracle9i architecture by looking at the background processes in a single-instance database.


For more information, see the book Oracle 11g Grid and Real Application Clusters  - 30% off if you buy it directly from Rampant TechPress .  Written by top Oracle experts, this RAC book has a complete online code depot with ready to use RAC scripts.


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.

 

 


 

 

  
 

 
 
 
 
Oracle performance tuning software
 
 

 

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

Fast-Track Oracle Support
PO Box 511
Kittrell, NC 27544


Email BC: