SELECT DISTINCT metric_name FROM v$sysmetric_history;

ALTER session SET nls_date_format='DD.MM.YYYY HH24:MI:SS';

SELECT * FROM v$sysmetric WHERE metric_name='Host CPU Utilization (%)';

или

SELECT BEGIN_TIME
     , END_TIME
     , METRIC_NAME
     , MAXVAL
     , MINVAL
     , AVERAGE 
FROM v$sysmetric_summary 
WHERE metric_name='Host CPU Utilization (%)';

SELECT * FROM v$sysmetric_history WHERE metric_name='Host CPU Utilization (%)' ORDER BY value DESC;

SELECT * FROM v$sysmetric_history WHERE metric_name='Full Index Scans Per Sec' ORDER BY value DESC;