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

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Tue, 26 Mar 2013 12:32:18 -0700 (PDT)
Message-ID: <1364326338.37694.YahooMailClassic_at_web181204.mail.ne1.yahoo.com>

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

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

Received on Tue Mar 26 2013 - 20:32:18 CET