— show_awr_metrics
— quickly pull up the metrics being collected by AWR and the units

spool show_awr_metrics.lst
col grp form 999
col mtr_id for 99999
col group_name form a20 wrap
col metric_name form a22 wrap
col metric_unit form a22 wrap
select –dbid,
group_id      grp
,group_name
,metric_id   mtr_id
,metric_name
,metric_unit
from dba_hist_metric_name
where lower(metric_name) like ‘&metric’||’%’
order by 2,3,4,5
/
spool off