Friends
How do you usually measure the IOPS your DB has at peaks moments?
I mean, how to I get the maximum IOPS I ever head on my DB?
I found this query,
break on report
compute sum of value on report
select METRIC_NAME,avg(AVERAGE) value from dba_hist_sysmetric_summary
where METRIC_NAME in ('Physical Read Total IO Requests Per Sec','Physical Write Total IO Requests Per Sec')
group by METRIC_NAME;
But why AVG the measure, if we can get the maximum value? I want to see the maximum peak of IOPS i ever had.
How to you guys do that?
Tks a lot for sharing experiences