Intermediate view between V$EVENTMETRIC and DBA_HIST_SYSTEM_EVENT

From: Luis Santos <lsantos_at_pobox.com>
Date: Fri, 29 Jun 2018 09:18:58 -0300
Message-ID: <CAPWdmV-4YSzb2q-nWTG60ZmsDqGrj-LBB80a9rKcTEA840ka4g_at_mail.gmail.com>



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.

*--*
*Att*

*Luis Santos*

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 29 2018 - 14:18:58 CEST

Original text of this message