Return-Path: <root@fatcity.cts.com>
Received: from ensim.rackshack.net (root@localhost)
 by orafaq.net (8.11.6/8.11.6) with ESMTP id h01DPds06117
 for <oracle-l@orafaq.net>; Wed, 1 Jan 2003 07:25:39 -0600
X-ClientAddr: 209.68.248.164
Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164])
 by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h01DPcc06112
 for <oracle-l@orafaq.net>; Wed, 1 Jan 2003 07:25:38 -0600
Received: from fatcity.UUCP (uucp@localhost)
 by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id CAA78753;
 Wed, 1 Jan 2003 02:07:47 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005250DA; Wed, 01 Jan 2003 01:23:45 -0800
Message-ID: <F001.005250DA.20030101012345@fatcity.com>
Date: Wed, 01 Jan 2003 01:23:45 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
X-Comment: Oracle RDBMS Community Forum
X-Sender: JayK@ibsplc.com
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: JayK@ibsplc.com
Subject: How do I get the Physical Reads
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=_alternative 003110AC65256CA0_="
--=_alternative 003110AC65256CA0_=
Content-Type: text/plain; charset="us-ascii"

Hi all,

>From the Report.txt that I analysed, I found that the Physical Reads 
is 350215. I understand that this value denotes the number of
I/O requests given by Oracle to the OS to obtain the Data Blocks that 
it requires. This is infact a Buffer Cache Miss in that case.

I would like to know how I can find out the actual Disk I/O that
has occured for READ from Oracle. Wouldn't it be the same as the 
value indicated by Physical Reads in Report.txt , if the
File System Block Size is the same as the DB Block Size.

Best Regards
Jai
--=_alternative 003110AC65256CA0_=
Content-Type: text/html; charset="us-ascii"


<br><font size=2 face="sans-serif">Hi all,</font>
<br>
<br><font size=2 face="sans-serif">From the Report.txt that I analysed, I found that the Physical Reads </font>
<br><font size=2 face="sans-serif">is 350215. I understand that this value denotes the number of</font>
<br><font size=2 face="sans-serif">I/O requests given by Oracle to the OS to obtain the Data Blocks that </font>
<br><font size=2 face="sans-serif">it requires. This is infact a Buffer Cache Miss in that case.</font>
<br>
<br><font size=2 face="sans-serif">I would like to know how I can find out the actual Disk I/O that</font>
<br><font size=2 face="sans-serif">has occured for READ from Oracle. Wouldn't it be the same as the </font>
<br><font size=2 face="sans-serif">value indicated by Physical Reads in Report.txt , if the</font>
<br><font size=2 face="sans-serif">File System Block Size is the same as the DB Block Size.</font>
<br><font size=2 face="sans-serif"><br>
Best Regards<br>
Jai</font>
--=_alternative 003110AC65256CA0_=--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: JayK@ibsplc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).