Re: AWR report ... what does W/A MB processed represent?
- From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
- To: "John Hurley" <hurleyjohnb@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 26 Mar 2013 19:38:17 -0000
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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>; "Jonathan Lewis"
<jonathan@xxxxxxxxxxxxxxxxxx>
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
|
--
//www.freelists.org/webpage/oracle-l
Other related posts:
