RE: CPU rounding

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Gerry Miller
Sent: Thursday, November 17, 2011 4:13 AM
To: gerry@xxxxxxxxxxxxxxxxxxx
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

Other related posts: