RE: CWSPEEDNW/CPUSPEED vs. actual Cpu speed

From: Timur Akhmadeev <Akhmadeev_at_NetCracker.com>
Date: Tue, 31 Jul 2012 08:45:52 +0000
Message-ID: <FFB456FD9AC03C48B943326F553A70AC504A54E4_at_umaildb2.netcracker.com>

3rd table column with caption "ЦПУ(МГц)" is CPU speed in MHz. Other columns are 1 - CPU model, 2 - Server/Oracle version, 4 - Bus speed, 5 - CPUSPEEDNW, 6 - CPUSPEED, 7 - Source (link to the post). Regards
Timur Akhmadeev

-----Original Message-----
From: Kenneth Naim [mailto:kennethnaim_at_gmail.com] Sent: Friday, July 27, 2012 17:08
To: Timur Akhmadeev; carlos.sierra.usa_at_gmail.com Cc: 'Oracle-L Group'
Subject: RE: CWSPEEDNW/CPUSPEED vs. actual Cpu speed

Before posting I had goggled the topic and saw this thread. It was very interesting however the actual clock speed of the cpu's weren't posted so I didn't know if there was a correlation or not.

Thank you.
Ken

-----Original Message-----
From: Timur Akhmadeev [mailto:Akhmadeev_at_NetCracker.com] Sent: Friday, July 27, 2012 3:58 AM
To: carlos.sierra.usa_at_gmail.com; kennethnaim_at_gmail.com Cc: Oracle-L Group
Subject: RE: CWSPEEDNW/CPUSPEED vs. actual Cpu speed

BTW if you need some numbers to compare, here is a link to SQL.ru thread on this topic with CPUSPEED/CPUSEEDNW data for some CPUs/Oracle versions: http://www.sql.ru/forum/actualthread.aspx?tid=682014&pg=5&mid=10015821#10015821

Regards
Timur Akhmadeev
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carlos Sierra Sent: Thursday, July 26, 2012 23:04
To: kennethnaim_at_gmail.com
Cc: Oracle-L Group
Subject: Re: CWSPEEDNW/CPUSPEED vs. actual Cpu speed

Ken,
There is no direct correlation. The values that I have seen from many customers are in the range between 1,000 and 1,600.

Carlos

On Thu, Jul 26, 2012 at 12:55 PM, Kenneth Naim <kennethnaim_at_gmail.com>wrote:

> I have a system that when system stats are gathered (using either no
> workload or with a workload) show a value of about 1260 for
> cpuspeed/cpuspeednw. The server is IBM p7 with 3.5ghtz cpu's. I
> expected the values returned by oracle to be close to 3500. Is my
> assumption incorrect?
> Is there a direct correlation between actual clock speeds and the
> value reported by the database? DB version is 11.2.0.3.
>
>
> Thank you in advance,
>
> Ken
>
> _____
>
>
> Checked by AVG - www.avg.com
> Version: 2012.0.2197 / Virus Database: 2437/5156 - Release Date:
> 07/26/12
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Cheers -- Carlos Sierra
http://carlos-sierra.net/


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




________________________________
The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.

-----

Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5157 - Release Date: 07/26/12

-----

Checked by AVG - www.avg.com
Version: 2012.0.2197 / Virus Database: 2437/5158 - Release Date: 07/27/12



________________________________
The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential, proprietary and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer.
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 31 2012 - 03:45:52 CDT