 | | | CPU Time calculation in AWR Reports | CPU Time calculation in AWR Reports 2007-11-02 - By Jonathan Lewis
Back
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@(protected)>
> 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
|
|
|