Merging Performance data from multiple instance

[Brady, Mark]

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

[rjamya]

Mark,
*For past Performance*: if you have direct access to OEM repository db and
sql developer (or any other tool of your choice), you can run your own
graphs/reports by utilizing sysman.mgmt$metric_daily or
sysman.mgmt$metric_hourly views as needed. I have done it in the past, and
it can be easily done using APEX as well, in-fact that would make your
charting much easier.

*For Current Performance*: Most performance data is stored in individual
databases, so you will have to get it from individual database via
connection, pool it in an array and then graph. You also have to connect to
individual databases and keep refreshing that data. This is a bit
complicated.

Raj



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

[Marcus Mönnig]

Hi Mark,
Mumbai can do ASH graphs against multiple instances. See the lower part of
the 4th image on:
https://marcusmonnig.wordpress.com/2013/02/05/ash-data-viewer-in-mumbai-version-2-2-1-824/

If you want to try, you first need to setup all your connections in
Mumbai's connection dialog and, due to a bug, make sure you give all
connection a name.

HTH,
Marcus


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

[Karl Arao]

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

Post by Brady, Mark
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