Intermediate view between V$EVENTMETRIC and DBA_HIST_SYSTEM_EVENT

From: Luis Santos <>
Date: Fri, 29 Jun 2018 09:18:58 -0300
Message-ID: <>

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.


*Luis Santos*

Received on Fri Jun 29 2018 - 14:18:58 CEST

Original text of this message