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




Porting To Parallel Server

Oracle Tips by Mike Ault

Parallel Server

In Oracle parallel server two or more instances attach to the same database by use of the Oracle parallel cache management system. In shops that are used to addressing databases and instances as synonymous objects, this distinction can be confusing. Remember that an instance is the set of processes and the SGA (System Global Area) and the database is the set of database files. Unless the platform used for the parallel system is able to partition CPUs (such as in theE10000 from SUN) the instances in a parallel server must be on separate platforms running the same operating system, at the same version level and be running the identical version of Oracle with the parallel server option installed. Figure 3 shows the configuration for this option.


For more information on this topic, I recommend Don Burleson's latest book "Oracle Tuning: The Definitive Reference". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:

Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA




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. 

Hit Counter