Re: Help with reporting file IO activity for each tablesapce

CREATE TABLE tot_read_writes AS

   SELECT SUM(phyrds) phys_reads, sum(phywrts) phys_wrts    FROM V$FILESTAT;
TITLE ' Disk I/Os by Datafile '
SET PAGES 1000
SET LINES 120
COLUMN name FORMAT a60
COLUMN phyrds FORMAT 999,999,999
COLUMN phywrts FORMAT 999,999,999
COLUMN read_pct FORMAT 999.99
COLUMN write_pct FORMAT 999.99
SELECT name, phyrds * 100 / trw.phys_reads read_pct,

       phywrts, phywrts * 100 / trw.phys_wrts write_pct FROM tot_read_writes trw, v$datafile df, v$filestat fs WHERE df.file# = fs.file#
ORDER BY phyrds desc;

"Andy Trigg" <atrigg_at_optusnet.com.au> wrote in message news:3c4a9f47$0$4019$afc38c87_at_news.optusnet.com.au...
> I am trying to design a script that will provide me with the file IO
> activity that is occuring for each table space. I have had a look at the
> utlbstat.sql/utlestat.sql script pair. These produce closely to what I
want
> except they only show the number of reads and writes that have occured and
> not the actualy number of bytes read or written. I am really after the
> activity measured in bytes.
>
> Can any body give me any idea how I can extrapolate this type of
> information? I need the solution to be OS independant. So suggesting using
> perfmon on NT is not an option. I really would like an Oracle script to
> achieve this.
> Thanks in advance.
>
> Andy
>
>
>
Received on Tue Jan 22 2002 - 15:05:22 CST