Re: using all available CPUs

From: Paul Bennett <bennett_at_cc.gatech.edu>
Date: Thu, 30 Dec 1999 18:06:43 GMT
Message-ID: <386B9F69.3A953ECC@cc.gatech.edu>

Short answer:

The database, schema, and application all have to be written to utilize the extra processors.

Cant just do

USE_ALL_PROCESSORS = 1 There is a good discussion on parallel execution in Chapter 21 of Oracle Server Concepts manual.

Paul

Verna Legaspi wrote:

> Hello. We have a Sun E4000 with 6 CPUs. Running Solaris 2.6 & Oracle
> 8.0.5. Is there some parameter, setting, option, etc. that I need to
> configure in order for Oracle to take advantage of all the CPUs? Or is this
> only something that can be done on the SQL side?
Received on Thu Dec 30 1999 - 12:06:43 CST