Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 'CPU used when call started' vs 'CPU used by this session'

'CPU used when call started' vs 'CPU used by this session'

From: Rene Nyffenegger <rene.nyffenegger_at_gmx.ch>
Date: 25 Mar 2005 20:52:36 GMT
Message-ID: <3ajc0kF68q6b1U2@individual.net>


Hello

I have recently read somewhere that the statistics (from v$sesstat/mystat/sysstat)
'CPU used when call started' and
'CPU used by this session' are (nearly) equivalent
but that 'CPU used when call started' should be used instead of 'CPU used by this session' because the latter is buggy.

Now, is that true?

And if so, why does Oracle have two statistics for the same thing.

If not so, what is the difference.

I have played a bit with it and indeed, the values seem to be identical for both statistics.

Thanks,
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/
Received on Fri Mar 25 2005 - 14:52:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US