RE: AWR logical reads question

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Thu, 16 Aug 2012 23:29:54 +0000
Message-ID: <A250F0C68C23514CA9F3DF63D60EE10E163FDC8C_at_onews31>

Never mind - that would be part of physical reads, not logical reads.

-----Original Message-----

From: Allen, Brandon
Sent: Thursday, August 16, 2012 4:28 PM
To: 'kmoore_at_zephyrus.com'; oracle-l_at_freelists.org Subject: RE: AWR logical reads question

Maybe you're missing direct reads?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

Received on Thu Aug 16 2012 - 18:29:54 CDT