Re: CPU_COUNT
From: Sue <sueschoch_at_gmail.com>
Date: Fri, 4 Sep 2009 12:04:51 -0700 (PDT)
Message-ID: <07fa9bad-9bee-4917-80be-7efb89332c28_at_j39g2000yqh.googlegroups.com>
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.
Date: Fri, 4 Sep 2009 12:04:51 -0700 (PDT)
Message-ID: <07fa9bad-9bee-4917-80be-7efb89332c28_at_j39g2000yqh.googlegroups.com>
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 Received on Fri Sep 04 2009 - 14:04:51 CDT