Oracle Database

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;
Print Friendly, PDF & Email

Leave a Reply

Your email address will not be published. Required fields are marked *

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