Disk IO

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;

Leave a Comment

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