Re: AWR report ... what does W/A MB processed represent?

John,

A quick sanity check - if you look at the workarea histogram figures on the report then W/A MB probably ought to be in the same ballpark as the mid-point of each range multiplied by the number of executions.for the range. (Though maybe that approximation will be spoiled by one-pass and multipasses.)

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543

• Original Message ----- From: "John Hurley" <hurleyjohnb_at_yahoo.com> To: <oracle-l_at_freelists.org>; "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> Sent: Tuesday, March 26, 2013 7:32 PM Subject: Re: AWR report ... what does W/A MB processed represent?

| Thanks Jonathan but while I do have a potentially larger PGA we seem to
be using about as much as before.
|
| I am now pretty convinced that 11.1.0.7 is just "not dividing" the (
bytes processed from v$pgastat ) by 1024*1024 for the AWR report but 11.2.0.3 has this calculation fixed and is calculating MB correctly.
|
| My last 11.1 system is migrated but I was getting numbers in there that
were huge.
|
| Can some other people do some double checking please?
|
| Thanks John
|
|
| -----
| No virus found in this message.
| Checked by AVG - www.avg.com
| Version: 2013.0.2904 / Virus Database: 2641/6202 - Release Date: 03/24/13
|

--
http://www.freelists.org/webpage/oracle-l