Re: CPU_COUNT
From: joel garry <joel-garry_at_home.com>
Date: Fri, 4 Sep 2009 16:19:45 -0700 (PDT)
Message-ID: <741e3169-a277-4ef4-a6d5-a07a4e41ab56_at_w37g2000prg.googlegroups.com>
On Sep 4, 12:04 pm, Sue <suesch..._at_gmail.com> wrote:
> We're trying to determine how many CPUs we need to license. We have
> way more machine than we can afford to license so we plan on using
> Solaris containers to partition it. I realize that generally you
> don't set this and we won't either once we figure out what we need. I
> set CPU_COUNT to 1 thinking it would use 1 cpu/4cores but I can't tell
> what it's doing. It appears to be using less than 4 cores. We
> initially brought the machine up with no CPU restrictions, then set to
> 1 and are really feeling the change.
>
> 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.
>
> Sue
Date: Fri, 4 Sep 2009 16:19:45 -0700 (PDT)
Message-ID: <741e3169-a277-4ef4-a6d5-a07a4e41ab56_at_w37g2000prg.googlegroups.com>
On Sep 4, 12:04 pm, Sue <suesch..._at_gmail.com> wrote:
> We're trying to determine how many CPUs we need to license. We have
> way more machine than we can afford to license so we plan on using
> Solaris containers to partition it. I realize that generally you
> don't set this and we won't either once we figure out what we need. I
> set CPU_COUNT to 1 thinking it would use 1 cpu/4cores but I can't tell
> what it's doing. It appears to be using less than 4 cores. We
> initially brought the machine up with no CPU restrictions, then set to
> 1 and are really feeling the change.
>
> 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.
>
> Sue
Maybe this will help:
http://wikis.sun.com/display/BluePrints/Best+Practices+for+Running+Oracle+Databases+in+Solaris+Containers
jg
-- _at_home.com is bogus. Lucky 13. http://news.techworld.com/security/3201054/oracle-to-delay-security-updates/?olo=rssReceived on Fri Sep 04 2009 - 18:19:45 CDT