Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: data file disk read/write rate
"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