Re: AWR logical reads question
From: Karl Arao <karlarao_at_gmail.com>
Date: Fri, 17 Aug 2012 10:52:33 -0500
Message-ID: <CACNsJneHe9MGw0m07Fg1kKTTVxvOsFYoO0cmtrdb_1jyHfDvFg_at_mail.gmail.com>
Not sure.. but the 101% may come from adding all the logical reads values of the dba_hist_seg_stat (not doing a top N) then divide it by the session logical reads
of course they are coming from different sources so there may be instrumentation differences between dba_hist_seg_stat=logical reads and dba_hist_sysstat=session logical reads
Just like on the CPU time where you can pull it on different sources like dba_hist_sys_time_model or dba_hist_sysstat or on ASH which is detailed here http://goo.gl/5WaAg
Date: Fri, 17 Aug 2012 10:52:33 -0500
Message-ID: <CACNsJneHe9MGw0m07Fg1kKTTVxvOsFYoO0cmtrdb_1jyHfDvFg_at_mail.gmail.com>
Not sure.. but the 101% may come from adding all the logical reads values of the dba_hist_seg_stat (not doing a top N) then divide it by the session logical reads
of course they are coming from different sources so there may be instrumentation differences between dba_hist_seg_stat=logical reads and dba_hist_sysstat=session logical reads
Just like on the CPU time where you can pull it on different sources like dba_hist_sys_time_model or dba_hist_sysstat or on ASH which is detailed here http://goo.gl/5WaAg
--
Karl Arao
karlarao.wordpress.com
karlarao.tiddlyspot.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Aug 17 2012 - 10:52:33 CDT