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@xxxxxxxxxxxxxxxxxx> 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 calculateCPU time asCPU 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
-- //www.freelists.org/webpage/oracle-l