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: Tom Best <tombest_at_firstusa.com>
Date: 21 Sep 2001 05:59:54 -0700
Message-ID: <99ab87b0.0109210459.12a1ff98@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!

Phil:

Run utlbstat/utlestat gathering statistics. Look in the stats report file at the results of this query:

SVRMGR> Rem I/O should be spread evenly accross drives. A big difference between
SVRMGR> Rem phys_reads and phys_blks_rd implies table scans are going on.
SVRMGR> select table_space, file_name,

     2> phys_reads reads, phys_blks_rd blks_read, phys_rd_time read_time,

     3> phys_writes writes, phys_blks_wr blks_wrt, phys_wrt_tim write_time,

     4>        megabytes_size megabytes
     5>  from stats$files order by table_space, file_name;

Hope this helps.
Tom Best Received on Fri Sep 21 2001 - 07:59:54 CDT

Original text of this message

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