Chris Kirke (cakirke@multiservice.com) wrote:
: any ideas on oracle's use of the cpu_count init file parameter ??
: if i don't set it, a query of v$parameter shows it still set to 1
: on a multi-processor system.
:
: SCO Open Server 5.0.4 w/mpx (2 or 4 processors)
: Oracle7 RDBMS V7.3.2.3
:
: thanks,
: Chris
Chris,
You are correct - Oracle does not automatically detect the number of CPUs
on startup. By default the cpu_count will be 1. If you need to change it,
you must specify it in the init.ora parameter file.
______________________________________________________________________________________________
Elzbieta Radziszewska (eradziszewska@dor.state.in.us) writes:
Hello Mr. Kaplan,
I just saw your Web Page and read a few of your responses. Majority of them
were excellent except for one that puzzled me.
First of all, cpu_count is one of the parameters which is set up by Oracle
automatically and it should not be reset by the dba. I have seen a few
databases and always cpu_count corresponded to actual number of available
CPUs. Chris mentioned that he/she is dealing with multiprocessor system.
However, he/she did not specify the actual number of CPUs. My guess is that
it was set to 1 in 2 processor environment. In Oracle 7 documentation you
can read that on computers with one CPU, cpu_count was set to 0. Newer
versions of Oracle Server are setting this parameter to 1 if actual number
of CPUs is 1. Please, refer to Oracle documentation. Once again, I really
like your Web Page and think that it is very useful.
My best regards,
--Elzbieta Radziszewska
______________________________________________________________________________________________
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page