Re: Merging Performance data from multiple instance
- From: Karl Arao <karlarao@xxxxxxxxx>
- To: mbrady@xxxxxxxxxxxxxxxx
- Date: Sun, 18 Aug 2013 16:53:43 +0800
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@xxxxxxxxxxxxxxxx>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.
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Karl Arao
Blog: karlarao.wordpress.com
Wiki: karlarao.tiddlyspot.com
Twitter: @karlarao <http://twitter.com/karlarao>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
