Re: One simple question

Thanks Robert:

15:45:13 SQL> l
  1 select kviival Num_CPU, kviidsc DESCRIPTION   2 from sys.x$kvii
  3* where kviitag= 'ksbcpu'
15:45:16 SQL> /
more..

   NUM_CPU DESCRIPTION

---------- ----------------------------------------------------------------
         4 number of CPUs in the system

CPU_COUNT seems to show a wrong number. hmm... I do not know about dual core processor. Will the SAs be able to answer that question?

On 8/29/06, Robert Freeman <robertgfreeman_at_yahoo.com> wrote:
>
> The following query will tell you how many CPU's
> Oracle thinks is on your system:
>
> select kviival Num_CPU, kviidsc DESCRIPTION
> from sys.x$kvii
> where kviitag='ksbcpu_static';
>
> Oracle has been known in the past to set CPU_COUNT to
> something other than the # of CPU's.
>
> RF
> --- Ram Raman <veeeraman_at_gmail.com> wrote:
>
> > I am little confused here. I tried to find out the
> > number of CPUs using
> > cpu_count, I get 8. When I do mpstat I get 4 rows.
> > Am I missing something
> > here? Solaris 8.
> >
> >
> >
>
> --------------------------------------------------------------------------------------------------------------------------------------
> > ATTACHMENT:
> >
> > SQL> show parameter cpu_count
> > NAME TYPE
> > VALUE
> > ------------------------------------ -----------
> > ------------------------------
> > cpu_count integer 8
> > SQL> exit
> > Disconnected from Oracle9i Enterprise Edition
> > Release 9.2.0.6.0 - Production
> > With the Partitioning, OLAP and Oracle Data Mining
> > options
> > JServer Release 9.2.0.6.0 - Production
> >
> > PROMPT% mpstat
> > CPU minf mjf xcal intr ithr csw icsw migr smtx
> > srw syscl usr sys wt idl
> > 8 23 3 223 38 27 320 4 18 10
> > 3 5 10 3 3 84
> > 9 24 4 101 10 3 327 4 18 9
> > 3 28 11 2 3 83
> > 10 24 3 601 87 80 322 4 17 10
> > 3 28 10 3 3 84
> > 11 24 3 59 32 25 319 4 17 9
> > 3 31 11 3 3 84
> > PROMPT% uname -r
> > 5.8
> >
> > ====================================================
> >
>
>
> Robert G. Freeman
> Author:
> Portable DBA: Oracle (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Oracle9i RMAN Backup and Recovery (Oracle Press)
> Oracle9i New Features (Oracle Press)
> Oracle Replication (Rampant Tech Press)
> Mastering Oracle8i (Sybex)
> Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>)
> Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)
>

--
http://www.freelists.org/webpage/oracle-l