Re: cpu_count

Jan Coekelberghs wrote:

> On Thu, 5 Feb 1998 11:01:01 -0600, "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
> >
> In Oracle 7.3.2.3 on HP-UX this is a bug. I got the patch last week.
> Contact Oracle Customer Support and ask for the patch on SCO.
>
> Jan

This bug is specific to HP so there's no patch for SCO.

Try to look in the X$KVII table instead:

SQL> select kviival from x$kvii where kviidsc = 'number of CPUs in the system';

/Jesper

--
.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.

|
|
|                            Jesper
 Søndergaard                              |
|                            Technical
 Analyst                              |
|
|
| Email:     jsoender_at_dk.oracle.com                 Oracle
 Danmark           |
| Office:    +45 4480 8081                          Lautrupbjerg
 2-6         |
| Direct:    +45 4480 4269                          DK-2750
 Ballerup         |
|
|
'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'´`'·.,,.·'

         The statements and opinions expressed here are my own and
         do not necessarily represent those of Oracle Corporation.