Re: Load Statistics of different databases from cloud control

Hi

MGMT$METRIC_CURRENT needs Diagnostics Pack license but since you are using AWR i guess you already have the license

On Tue, Nov 8, 2022 at 3:50 PM Lothar Flatz <l.flatz_at_bluewin.ch> wrote:

> 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