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;