Re: data file disk read/write rate

If you are on 8i rel 2 and up, use statspack. Musch better reporting than utlbstat/utlestat and it keeps soem history.

James

In article <99ab87b0.0109210459.12a1ff98_at_posting.google.com>, Tom Best <tombest_at_firstusa.com> wrote:

> "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 - 08:15:00 CDT