Re: AWR logical reads question
From: Keith Moore <kmoore_at_zephyrus.com>
Date: Fri, 17 Aug 2012 10:11:08 -0500
Message-ID: <e9ace629432572568918126bdc388a72.squirrel_at_lady.zephyrus.com>
That is it. Thanks for your help.
Date: Fri, 17 Aug 2012 10:11:08 -0500
Message-ID: <e9ace629432572568918126bdc388a72.squirrel_at_lady.zephyrus.com>
That is it. Thanks for your help.
The value is from DBA_HIST_SYSSTAT. I looked there but just scanned through the list for "logical reads' and not "session logical reads". Doh!
One followup. I noticed in your example that the percent is over 100% and I have seen that in other reports. Any idea how the sum of the object percentages could be more than 100% of the total?
Keith
> Check out the sample AWR here http://goo.gl/x7fXS that total should come
> from "session logical reads" then divide it by the object.. then you'll get
> the percentage..
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Aug 17 2012 - 10:11:08 CDT