alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';
alter session set NLS_NUMERIC_CHARACTERS= '.,';
grant select on sysman.mgmt_targets to mgmt_user;
select target_name --, column_label, 
,avg(to_number(value)) avg_disk_readwrites_persec, max(to_number(value)) max_disk_readwrites_persec
--target_name, column_label, collection_timestamp, to_number(value) --, * --target_name, target_type, metric_name, metric_column, metric_label,column_label, collection_timestamp, value
  from SYSMAN.MGMT$METRIC_DETAILS
--where columN_label = 'Total Disk I/O Per Second'
where (columN_label = 'Disk Reads (per second)' or columN_label = 'Disk Writes (per second)')
and target_guid in (select target_guid from sysman.mgmt_targets --where upper(target_name) --like 'SDPHQOKORAES5%'
)
and key_value like '%D:%'
--and collection_timestamp between to_date('10/23/2013 8:00:00','MM/DD/YYYY HH24:MI:SS') 
and collection_timestamp between trunc(sysdate)-1+8/24
and trunc(sysdate)-1+16/24
group by target_name --, column_label
--order by target_name, collection_timestamp
order by 2 desc
/
select sum(avg(to_number(value))) avg_disk_readwrites_persec, sum(max(to_number(value))) max_disk_readwrites_persec
--target_name, column_label, collection_timestamp, to_number(value) --, * --target_name, target_type, metric_name, metric_column, metric_label,column_label, collection_timestamp, value
  from SYSMAN.MGMT$METRIC_DETAILS
--where columN_label = 'Total Disk I/O Per Second'
where (columN_label = 'Disk Reads (per second)' or columN_label = 'Disk Writes (per second)')
and target_guid in (select target_guid from sysman.mgmt_targets --where upper(target_name) --like 'SDPHQOKORAES5%'
)
and key_value like '%D:%'
--and collection_timestamp between to_date('10/23/2013 8:00:00','MM/DD/YYYY HH24:MI:SS') 
and collection_timestamp between trunc(sysdate)-1+8/24
and trunc(sysdate)-1+16/24
group by target_name --, column_label
--order by target_name, collection_timestamp
order by 2 desc
/