Oracle Database Discussions

Hello ,

Please suggest , acording to the query in 10.2.0.5v. :

User I/O :

select to_char(w.begin_time,'YYYY.MM.DD HH24:MI:SS') laikas,
ROUND(10*w.time_waited/DECODE(w.wait_count,0,1,w.wait_count),2) "AVG_IO_MS", w.wait_count
FROM v$WAITCLASSMETRIC_HISTORY w,V$SYSTEM_WAIT_CLASS c
where w.wait_class_id=c.wait_class_id and c.wait_class='User I/O'
order by w.begin_time,c.wait_class
;

, averaged by 1 min. i am getting the random spikes :

TIME AVG_IO_MS WAIT_COUNT

2013.02.12 12:15:49 5,1 220
2013.02.12 12:16:49 7,03 79
2013.02.12 12:17:48 5,17 354
2013.02.12 12:18:48 86,58 320
2013.02.12 12:19:49 4,2 305
2013.02.12 12:20:49 6,66 192
2013.02.12 12:21:49 2,72 904
2013.02.12 12:22:49 5 539
2013.02.12 12:23:48 6,17 271
2013.02.12 12:24:48 2,62 786
2013.02.12 12:25:49 5,74 356
2013.02.12 12:26:49 6,95 180
2013.02.12 12:27:49 4,42 508
2013.02.12 12:28:49 7,02 292
2013.02.12 12:29:48 3,49 222
2013.02.12 12:30:48 3,47 2226
2013.02.12 12:31:49 95,92 841
2013.02.12 12:32:49 5,08 1304
2013.02.12 12:33:49 5,85 771
2013.02.12 12:34:48 5,5 369
2013.02.12 12:35:48 332,82 307
2013.02.12 12:36:48 4,66 354

Can i state from this query , that there is SAN Disk I/O problem .
Because SAN sysadm. states that this is O.K .

Thank's

Edited by: user11977218 on Feb 12, 2013 12:41 PM

Edited by: user11977218 on Feb 12, 2013 12:42 PM

Edited by: user11977218 on Feb 12, 2013 12:48 PM