RE: Physical reads -oops

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 30 Dec 2002 02:43:51 -0800
Message-ID: <F001.005240EB.20021230024351@fatcity.com>

('binary' encoding is not supported, stored as-is)
Ooops. Read too fast. Blocks. You may be interested in checking against V$FILESTAT, where you have both actual 'numbers of requests' of reads/writes and 'numbers of blocks'. Dismally close on some databases, BTW.

>----- Original Message -----
>From: pradeep_at_ibsplc.com
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Mon, 30 Dec 2002 01:23:44
>
>
>Hi All in list,
>
>I have taken the report.txt using utlbstat and
>utlestat. Can I assume
>that the physical reads value as number of physical
>I/Os to the disk
>happened?
>
>
>Regards,
>Pradeep
>
>--
>Please see the official ORACLE-L FAQ:
>http://www.orafaq.net
>--
>Author:
> INET: pradeep_at_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_at_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).
>---------------------------------------------------
>------------------

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: sfaroult_at_oriolecorp.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_at_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).

Received on Mon Dec 30 2002 - 04:43:51 CST