RE: CPU Time calculation in AWR Reports

I think I'm about to have demonstrated to me (offline) that the comment below is complete garbage. So my apologies and please ignore it.

It's a bit sad in some ways because I'd already blogged about it: (http://jonathanlewis.wordpress.com/2007/11/01/awr-oddity/) - but I'll be recanting on he blog as well.

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

• Original Message -----
  > From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
  > Subject: RE: CPU Time calculation in AWR Reports
  > Date: Thu, 1 Nov 2007 18:32:05 -0000
  >
  > 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