Re: Intermediate view between V$EVENTMETRIC and DBA_HIST_SYSTEM_EVENT
Date: Fri, 29 Jun 2018 13:33:33 +0000
Message-ID: <MM1P123MB08426A94D9C0347B5E89746DA54E0_at_MM1P123MB0842.GBRP123.PROD.OUTLOOK.COM>
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.
Regards
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.
--
[https://lh3.googleusercontent.com/-AD-URpt0jeE/AAAAAAAAAAI/AAAAAAAB-9c/LrffscVVpf8/s90-c-k/photo.jpg]
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Luis Santos <lsantos_at_pobox.com>
Sent: 29 June 2018 13:18
To: ORACLE-L
Subject: Intermediate view between V$EVENTMETRIC and DBA_HIST_SYSTEM_EVENT
Att
Luis Santos
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 29 2018 - 15:33:33 CEST