Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: CPU Time calculation in AWR Reports

RE: CPU Time calculation in AWR Reports

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 1 Nov 2007 18:32:05 -0000
Message-ID: <00e601c81cb5$8126ef90$0200a8c0@Primary>

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

Received on Thu Nov 01 2007 - 13:32:05 CDT

This message: [ Message body ]
Next message: Powell, Mark D: "RE: anyway to trace a DDL statement?"
Previous message: Allen, Brandon: "RE: WRONG RESULTS bug in 9.2.x, 10.1.x and 10.2.x"
Maybe in reply to: Luis Fernando Cerri: "CPU Time calculation in AWR Reports"
Next in thread: Jonathan Lewis: "RE: CPU Time calculation in AWR Reports"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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