RE: AWR logical reads question
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "kmoore@xxxxxxxxxxxx" <kmoore@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 16 Aug 2012 23:28:10 +0000
Maybe you're missing direct reads?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Keith Moore
The part I can't figure out is where the total logical reads comes from. I can
query the CONSISTENT_GETS column of DBA_HIST_BUFFER_POOL_STAT and get
reasonable close and get within about 1.5% if I also add in DB_BLOCK_GETS but
can't get to the exact total.
________________________________
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
http://www.freelists.org/webpage/oracle-l
Other related posts: