Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: data file disk read/write rate

Re: data file disk read/write rate

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 21 Sep 2001 01:58:06 -0700
Message-ID: <a20d28ee.0109210058.503e3333@posting.google.com> 





"phil" <phil_sheu_at_hotmail.com> wrote in message news:<57Bq7.309$4k2.254924_at_news.pacbell.net>...


> Hi,

> 

> Is there anyway to know that how many disk read per second on data files for

> a Oracle instance.

> 

> Thanks!




v$filestat


Timed_statistics in init.ora must be true
or 


you must use alter system set timed_statistics=true
before you select * from v$filestat



Hth,



Sybrand Bakker, Senior Oracle DBA
Received on Fri Sep 21 2001 - 03:58:06 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US