Re: Physical Reads and Writes

From: Martin Klier <usn_at_usn-it.de>
Date: Sat, 29 Aug 2009 13:24:11 +0200
Message-ID: <4A990FDB.7080907_at_usn-it.de>



Hi,

do you have perfstat or AWR available?

If yes, create a report and look up how much gets/reads/db file * read your DB and statements do. So you can get an idea what really happens, and afterwards compare it with OS metrics.

Regards
Martin Klier

Allen, Brandon schrieb:
> I forgot to mention, I’m not talking about the db cache here – those
> wouldn’t show up in the sar output at all, I’m talking about the
> filesystem buffer cache of your OS (unless you’re using direct or raw IO).
>
>
>
> Regards,
>
> Brandon
>
>
>
> *From:* Bill Zakrzewski [mailto:bill_at_intactus.com]
>
>
>
> very little chance all reads are satisfied by the database cache.
>
>
>
>
> ------------------------------------------------------------------------
> 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.

-- 
Usn's IT Blog for Linux, Oracle, Asterisk
http://www.usn-it.de

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Aug 29 2009 - 06:24:11 CDT

Original text of this message