Re: Merging Performance data from multiple instance
Date: Sun, 18 Aug 2013 16:53:43 +0800
Message-ID: <CACNsJnf4=yXL-2=Dcq2ttxs4j11cJ6AmP1YnR=t+5rT-CBrAkQ_at_mail.gmail.com>
depending on the data that you need let's say IOPS.. you can create a metrics extension then it will stage it to a metrics ext table then from there you can consume it with the BI publisher which integrates very well in oem12c
http://docs.oracle.com/cd/E24628_01/doc.121/e25353/whats_new.htm#CEGJAIIJ for adhoc consolidated visualization and whenever I go to environments where I need to do some initial workload characterization, troubleshooting, sizing, capacity planning, and resource management I pull all the AWR data from all the instances have them as one csv and consume it with tableau.. that works all the time.
but if you want it to be repeatable.. you can model your viz in tableau first.. then once you already have the final output that you need and of course you've validated that the aggregation is correct,etc,etc. then you can do the metrics extension + BI publisher route
just like what we did on a large customer environment where we compare side by side the IOPS coming from hard disk and flash from derived data of AWR and storage cell metrics pulled from cellcli commands.... this report is being sent to us daily and we can add thresholds and alerts around it. below is the sample viz
https://twitter.com/karlarao/status/368191042979262464
On Mon, Aug 12, 2013 at 11:27 AM, Brady, Mark <mbrady_at_allegisgroup.com>wrote:
> All
>
> I use Enterprise Manager to look at instance performance graphs. There are
> several instance for which I would like to see a combined or merged graph.
> Is it possible to do that within EM or do I need to union the ASH tables
> together and create my own graphs?
>
> Any suggestions would be helpful.
>
> I remember a presentation from someone at Hotsos who built an EM
> replacement in Python or some such. Is there a community tool that might
> have this capability?
>
>
> Mark Brady
>
> This electronic mail (including any attachments) may contain information
> that is privileged, confidential, and/or otherwise protected from
> disclosure to anyone other than its intended recipient(s). Any
> dissemination or use of this electronic mail or its contents (including any
> attachments) by persons other than the intended recipient(s) is strictly
> prohibited. If you have received this message in error, please notify us
> immediately by reply e-mail so that we may correct our internal records.
> Please then delete the original message (including any attachments) in its
> entirety. Thank you.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Karl Arao Blog: karlarao.wordpress.com Wiki: karlarao.tiddlyspot.com Twitter: _at_karlarao <http://twitter.com/karlarao> -- http://www.freelists.org/webpage/oracle-lReceived on Sun Aug 18 2013 - 10:53:43 CEST