[rescue] Looking for I/O performance metrics

[Steve Sandau]

I have an Oracle script that I use to measure relative disk usage, i.e.
checking to see that all the spindles with Oracle datafiles on them are
somewhat equally utilized. Don't know if it'll help, but here it is:
-------------------------------------
rem ioweights.sql
rem to find relative io weights of various files
rem queries v$filestat view for stats

set pagesize 60 linesize 80 newpage 0 feedback off
ttitle skip center "Database I/O Weights" skip center -
"ordered by drive" skip 2
column Total_IO format 999999999
column Weight format 999.99
column File_Name format A40
break on Drive skip 2
compute sum of Weight on Drive

select
substr(DF.name, 1,5) Drive,
DF.Name File_Name,
FS.Phyblkrd+FS.Phyblkwrt Total_IO,
100*(FS.Phyblkrd+FS.Phyblkwrt)/MaxIO Weight
from V$FILESTAT FS, V$DATAFILE DF,
  (select MAX(Phyblkrd+Phyblkwrt) MaxIO
    from V$FILESTAT)
where DF.File# = FS.File#
order by Weight desc

spool io_weights
/
spool off
------------------------------------
HTH


Chris Byrne wrote:
> 
> All,
> 
> I'm looking for some I/O measurement tools freely available for Solaris 2.6.
> I'm working on a SAN project at the moment and there's some weird stuff
> happening somewhere in the chain, and I need to isolate it. The sysadmin is
> saying that it's the SAN, the SAN people are blaming the Solaris config
> etc... etc... and I'm stuck in the middle.
> 
> Anyway the built-ins on Solaris are not as detailed (or way to detailed if I
> want to fully instrument the thing) as I'm going to need so I've been
> looking around for suggestions.
> 
> The systems are Solaris 2.6 running oracle 8i, and if anyone has ideas for
> oracle specific metrics I'd appreciate it.
> 
> Thanks
> 
> Chris Byrne
> 
> _______________________________________________
> rescue maillist  -  rescue at sunhelp.org
> http://www.sunhelp.org/mailman/listinfo/rescue

-- 
Steve Sandau
ssandau at bath.tmac.com