I/O times

  • From: Yechiel Adar <adar666@xxxxxxxxxxxx>
  • To: ORACLE-L@xxxxxxxxxxxxx
  • Date: Mon, 05 Jun 2006 10:17:01 +0200

Hello

I am doing a gross checking of performence.
Since we do regular snapshots, I wanted to see the I/O times during March and June.
Is the following good enough:


-- Mb stands for Multi Block, SB stands for Single Block.

select to_char(snap_time,'MM/DD') day ,

sum(phyrds) MB_read , sum(readtim) MB_time , sum(phyrds) / sum(readtim) single_mb_time ,

sum(SINGLEBLKRDS) SB_read, sum(SINGLEBLKRDTIM) SB_time, sum(SINGLEBLKRDS) / sum(SINGLEBLKRDTIM) single_SB_time,

sum(phywrts) WRITES, sum(writetim) WRITES_TIME, sum(phywrts) / sum(writetim) SINGLE_WRITE_TIME

from STATS$FILESTATXS a , STATS$SNAPSHOT b

where tsname = 'USERS'

   and a.snap_id = b.snap_id and TO_CHAR(b.snap_time, 'MM') in ('03','06')

   and to_char(snap_time,'HH') < '08'

group by to_char(snap_time,'MM/DD')

order by to_char(snap_time,'MM/DD')


-- Adar Yechiel Rechovot, Israel

--
//www.freelists.org/webpage/oracle-l


Other related posts: