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;