RE: CPU rounding

From: Jorgensen, Finn <Finn.Jorgensen_at_constellation.com>
Date: Thu, 17 Nov 2011 14:24:04 -0500
Message-ID: <9CE162BC5ED2C643956B526A7EDE46FF02A0A560E6BF_at_EXM-OMF-04.Ceg.Corp.Net>

I have your exact setup. Solaris 10 with EE 11.2.0.2. I get 4 zeroes at the end of all values.

Thanks,
Finn

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gerry Miller Sent: Thursday, November 17, 2011 4:13 AM To: gerry_at_millerandbowman.com
Cc: Oracle-L Group
Subject: Re: CPU rounding

Hi

I hate to bang on about this but I am no nearer to a solution.

We have 3 Solaris 10 boxes running 11.2.0.2 Enterprise Edition and the problem exists on all 3 and I would like to ask anyone with the same configuration out there to run:

    SELECT value FROM v$sess_time_model WHERE stat_name = 'DB CPU'; and tell me if the results are rounded to centiseconds, that is, all end with 4 zeroes.

Thanks

Gerry

Gerry Miller wrote:
> Hi,
> Can any one help me get to the bottom of this?
>
> We have two Solaris servers one hosting Oracle 10.1 and the other
> 11.2. The CPU stats on the 11g box are rounded to centiseconds while
> on 10g they are
> inmicroseconds:
>
> Example:
> In 11g: select value from v$sys_time_model where stat_name = 'DB CPU';
> VALUE
> -----------
> 27089090000
>
> In 10g: select value from v$sys_time_model where stat_name = 'DB CPU';
> VALUE
> -------------
> 1373214613234
>
> It is the same in v$sess_time_model and I suspect it is an OS setting
> that isat the root of the issue.
>
>
> Regards
>
> Gerry Miller
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

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




>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee.  If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1


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

Received on Thu Nov 17 2011 - 13:24:04 CST