RE: CPU rounding
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 21 Oct 2011 16:03:19 +0100
Gerry, the Reference manual says the value is measured in microseconds so what
makes you think the value is in centi-seconds? Since v$ views are generally
since instance startup the comparison between the two version would only be
relative if the two instance have the same start time. Is this true?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Gerry Miller
Sent: Friday, October 21, 2011 3:14 AM
To: Oracle-L Group
Subject: CPU rounding
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
