Re: Merging Performance data from multiple instance
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 13 Aug 2013 07:45:02 -0400
Message-ID: <CAGurbTPys0KytSDcATREF8Mz=ZrAUQcfiWc2HRPbof_B+tW-qQ_at_mail.gmail.com>
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.
Date: Tue, 13 Aug 2013 07:45:02 -0400
Message-ID: <CAGurbTPys0KytSDcATREF8Mz=ZrAUQcfiWc2HRPbof_B+tW-qQ_at_mail.gmail.com>
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-lReceived on Tue Aug 13 2013 - 13:45:02 CEST