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@xxxxxxxxx> 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@xxxxxxxxx> 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>)

Other related posts: