Re: Load Statistics of different databases from cloud control

Hi Niall,

thanks, that is it. Now I remember I have seen this before. Kind of hard to google, too generic terms.

Does anybody know caveats on this source?

Thanks

Lothar

Am 08.11.2022 um 15:22 schrieb niall.litchfield_at_gmail.com:
> Hi Lothar
>
> I haven't looked at the details for that page, but you should be able
> to do what you want with the MGMT$METRIC_CURRENT|HOURLY|DAILY views.
> https://docs.oracle.com/cd/E63000_01/EMVWS/monview.htm#EMVWS12360
>
> On Tue, Nov 8, 2022 at 12:11 PM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:
>
> Hi,
>
> I want to visualize Resource usage of different databases on a
> timeline.
> As each individual database provides AWR data, it would still be
> necessary to consolidate the data.
> Cloud control however is able to produces heat maps of e.g. CPU Usage.
> So that is already a consolidated view.
> Is this data available to queries? How is it accessed?
>
> Thanks
>
> LOthar
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l