Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle-l »

RE: CPU Time calculation in AWR Reports

Jonathan Lewis

2007-11-01



There's a bug in AWR - it seems to calculate
CPU time as

  CPU used by this session +
  recursive cpu usage

Worst case, if all you ever do is call pl/sql to wrap
SQL, is that the CPU time is double-counted.


Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.