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
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.