Disk IO_WAIT

SELECT  target_name, round(avg(average),2)
  FROM mgmt$metric_daily
WHERE     column_label = 'Total Disk I/O made across all disks (per second)'
    AND rollup_timestamp >= sysdate-14
    AND rollup_timestamp <= sysdate
group by target_name
order by 2 desc;

Up to 2000 is low (normal)
Between 2000-5000 is busy
over 5000 is high
over 10000 is extreme

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.