RE: CPU Time calculation in AWR Reports

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • 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.


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ


Other related posts: