FAQ
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

Search Discussions

  • Dennis Williams at Aug 29, 2006 at 8:07 pm
    Ram,

    Try /usr/sbin/psrinfo �v

    Dennis Williams
    On 8/29/06, Ram Raman 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

    ====================================================
    --
    http://www.freelists.org/webpage/oracle-l
  • Ram Raman at Aug 29, 2006 at 8:20 pm
    Here is the output:

    PROMPT% /usr/sbin/psrinfo -v

    Status of processor 8 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 9 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 10 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 11 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    On 8/29/06, Dennis Williams wrote:

    Ram,

    Try /usr/sbin/psrinfo –v

    Dennis Williams

    On 8/29/06, Ram Raman 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

    ====================================================
    --
    http://www.freelists.org/webpage/oracle-l
  • VIVEK_SHARMA at Aug 29, 2006 at 8:26 pm
    Is it a case of DUAL Core processors?

    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Ram Raman
    Sent: Wednesday, August 30, 2006 1:50 AM
    To: Dennis Williams
    Cc: oracle-l
    Subject: Re: One simple question

    Here is the output:

    PROMPT% /usr/sbin/psrinfo -v

    Status of processor 8 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 9 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 10 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.
    Status of processor 11 as of: 08/29/06 15:15:31
    Processor has been on-line since .
    The sparcv9 processor operates at MHz,

    and has a sparcv9 floating point processor.

    On 8/29/06, Dennis Williams wrote:

    Ram,

    Try /usr/sbin/psrinfo -v

    Dennis Williams

    On 8/29/06, Ram Raman 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

    CAUTION - Disclaimer *****************
    This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
    ***INFOSYS******** End of Disclaimer ********INFOSYS***
  • Ram Raman at Aug 29, 2006 at 8:50 pm
    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 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 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 )
    Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis )
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 29, '06 at 7:59p
activeAug 29, '06 at 8:50p
posts5
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase