Re: CPU_COUNT

From: <sybrandb_at_hccnet.nl>
Date: Fri, 04 Sep 2009 23:54:23 +0200
Message-ID: <7033a5tqs0l43jc2q6oca159c7219b1bjf_at_4ax.com>

On Fri, 4 Sep 2009 12:04:51 -0700 (PDT), Sue <sueschoch_at_gmail.com> wrote:

>SQL> select * from dba_cpu_usage_statistics;
> DBID VERSION TIMESTAMP CPU_COUNT
>CPU_CORE_COUNT CPU_SOCKET_COUNT
>---------- ----------------- ------------------- ----------
>-------------- ----------------
>1055427977 11.1.0.7.0 08/22/2009 22:09:14
>32 16 4
>1055427977 11.1.0.7.0 08/31/2009 22:41:41
>1 16 4
>
>This is actually a 4 CPU machine with 4 cores per CPU. Thanks for
>any help. I've been searching metalink but not finding what I'm
>looking for.

I don't think so. The math is quite simple. You have 4 cpu's with 4 cores, so CPU_COUNT will be 16. (As you see above).
If you set CPU_COUNT to 1, you will use 1 core of 1 cpu. Not that it matters as you do not pay for the number of cores that you use, you pay for the number of cores in the server.

-- 
-- 
Sybrand Bakker
Senior Oracle DBA

Received on Fri Sep 04 2009 - 16:54:23 CDT