Re: Physical Reads and Writes

  • From: Martin Klier <usn@xxxxxxxxx>
  • To: Brandon.Allen@xxxxxxxxxxx
  • Date: Sat, 29 Aug 2009 13:24:11 +0200

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@xxxxxxxxxxxx]
> 
>  
> 
> 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

--
//www.freelists.org/webpage/oracle-l


Other related posts: