Re: cpu_count

It is this way on HP-UX as well. Oracle's only intent here was to provide a way to override the built in detection. SHOW PARAMETER SPU_COUNT should report the correct number of CPU's. If not, use the init.ora setting to override it.

Mark Landa wrote:
>
> On Solaris/Sparc the number of CPUs is
> automatically detected and is correct according
> to v$parameter (v.7.3x).
>
> M.Landa
>
> Joel Garry wrote:
>
> > In article <6bfdk6$lkv$2_at_nntp3.interaccess.com>,
> > Ari Kaplan <akaplan_at_interaccess.com> wrote:
> > >Chris Kirke (cakirke_at_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.
> > >
> >
> > Since this directly conflicts with the 7.3 & 8.0 Server Refs, could you let
> > us know if it applies beyond SCO? (Specifically solaris sparc)
> >
> > >-Ari Kaplan
> > >Independent Oracle DBA Consultant
> > >
> > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > ><-> For 160+ Oracle tips, visit my Web Page: <->
> > ><-> <->
> > ><-> http://homepage.interaccess.com/~akaplan <->
> > ><-> <->
> > ><-> email: akaplan_at_interaccess.com <->
> > ><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
> > >
> >
> > --
> > These opinions are my own and not necessarily those of Information Quest
> > jgarry@eiq.com http://www.informationquest.com
> > http://ourworld.compuserve.com/homepages/joel_garry
> > "See your DBA?" I AM the @#%*& DBA!
Received on Tue Feb 17 1998 - 00:00:00 CST