It's not exactly what you want, but v$sysmetric_history (for group_id = 2) is a
minute by minute summary of about 160 critical metrics which might give you
what you need.
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Luis Santos <lsantos@xxxxxxxxx>
Sent: 29 June 2018 13:18
Subject: Intermediate view between V$EVENTMETRIC and DBA_HIST_SYSTEM_EVENT
Hi Oracle guys!
In a nutshell: V$EVENTMETRIC has the average wait times for the last minute.
And DBA_HIST_SYSTEM_EVENT has history average time. Not for the last minute,
but for AWR snap retention (column RETENTION from DBA_HIST_WR_CONTROL).
Is there a view that gives historical data for the V$EVENTMETRIC view? At
least for minutes up to last AWR interval...
In other words, if AWR snap interval is kept in the 1 hour default this view
would have 60 rows (last 60 minutes). If AWR snapshot interval is reduced to,
for example, 30 minutes, this view would store 30 rows.