From oracle-l-bounce@freelists.org Tue Apr 12 11:43:35 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3CGhZYY007049 for ; Tue, 12 Apr 2005 11:43:35 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3CGhZem007044 for ; Tue, 12 Apr 2005 11:43:35 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C9B7094311; Tue, 12 Apr 2005 10:41:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 12603-01; Tue, 12 Apr 2005 10:41:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4AE5D93D8E; Tue, 12 Apr 2005 10:41:24 -0500 (EST) Message-ID: <425BEBB8.3030506@pacbell.net> Date: Tue, 12 Apr 2005 08:39:36 -0700 From: Mark Bole User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: oracle-l@freelists.org Subject: Re: Dual core sun boxes References: In-Reply-To: Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-archive-position: 18385 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: makbo@pacbell.net Precedence: normal Reply-To: makbo@pacbell.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=AWL autolearn=ham version=2.60 X-Spam-Level: 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@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||'='||value from v$parameter where lower(name) like > '%cpu%count%'; > -- http://www.freelists.org/webpage/oracle-l