RE: Dual core sun boxes

From: Cunningham, Gerald <Gerald.Cunningham_at_usi.net>
Date: Tue, 12 Apr 2005 16:58:44 -0400
Message-ID: <E7650E6BCAF2414E8134C60A29AE28800307169A@ms3aex05.USIEXCHANGE.COM>

mdsuaor01> prtdiag
System Configuration: Sun Microsystems sun4u Sun Fire V890 System clock frequency: 150 MHz
Memory size: 16384 Megabytes

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
 CPUs
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

           Run   E$  CPU    CPU =20
Brd  CPU   MHz   MB Impl.   Mask=20
--- ----- ---- ---- ------- ----=20
 A  0, 16 1200 16.0 US-IV   2.4
 B  1, 17 1200 16.0 US-IV   2.4

 A 2, 18 1200 16.0 US-IV 2.4
 B 3, 19 1200 16.0 US-IV 2.4
[snip]

SQL> select name||'=3D'||value from v$parameter where lower(name) like   2 '%cpu%count%';

NAME||'=3D'||VALUE

---

---

cpu_count=3D8

=20

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DEEDSD_at_Nationwide.com
Sent: Tuesday, April 12, 2005 3:09 PM
To: oracle-l_at_freelists.org
Subject: Re: Dual core sun boxes

Actually, I should have phrased my question better - I already know that Oracle charges for both, but I have some database monitoring software that
charges by CPU as well and I need to know the results of the query because
those results determine how this vendor charges.

=20

                          Mark Bole

                          <makbo_at_pacbell.net>      T

                                                   To:

                          Sent by:                 cc:

oracle-l_at_freelists.org

                          oracle-l-bounce_at_freelis

                          ts.org                   bcc:

                                                   Subject:
Re: Dual core sun boxes      =20

=20

=20

=20

=20

                          04/12/2005 11:39 AM

                          Please respond to makbo

=20

=20

You can find the licensing guidelines at oracle.com which includes the following statement (quoted below) regarding dual core machines.

What I find very confusing, is that an Intel chip with hyperthreading enabled will show also show up as 2 CPU's both to the OS (e.g. Linux) and Oracle, yet my boss in a previous assignment said that the Oracle sales rep told him it still only counted as one CPU for licensing purposes. Go figure.

"When counting the number of processor licenses required, Oracle counts all the physical processors in a server where Oracle is installed and/or running. A multicore chip with N processor cores is treated as N processors. For example, a chip that has 2 processor cores on it, would need to be licensed for 2 processors, even though there is a single chip that holds the processors."

--
Mark Bole
http://www.bincomputing.com


DEEDSD_at_Nationwide.com wrote:

> Anyone have a daul core Sun database server?
>
> I'm working on some licensing issues for the dual core machines, and I
> don't have any in house yet to determine how Oracle reports the number
of
> CPUs.
>
> If someone has one, can you run this query and let me know what it
returns
> and how many physical CPUs are in the machine?
>
>       select name||'=3D'||value from v$parameter where lower(name) =
like
>       '%cpu%count%';
>


--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Apr 12 2005 - 17:03:19 CDT