Re: Grid Control Metrics Report

From: Job Miller <jobmiller_at_yahoo.com>
Date: Mon, 31 Aug 2009 09:38:54 -0700 (PDT)
Message-ID: <984965.82784.qm_at_web53905.mail.re2.yahoo.com>

Is this what you are looking for?
http://download.oracle.com/docs/cd/B16240_01/doc/em.102/b40007/views.htm#BACCEIBI MGMT$TARGET_METRIC_COLLECTIONS
MGMT$TARGET_METRIC_COLLECTIONS displays information about the metric collections

• On Mon, 8/31/09, Thomas Roach <troach_at_gmail.com> wrote:

From: Thomas Roach <troach_at_gmail.com> Subject: Grid Control Metrics Report
To: "Oracle Discussion List" <oracle-l_at_freelists.org> Date: Monday, August 31, 2009, 9:54 AM

Hi,
 

I want to identify what alerts Oracle Grid Control is polling for. (I'll query notification rules later).
 

I am trying to find a SQL statement to run against my GC repository. I found a table that "almost" gives me what I need (it actually gives me the column I need but it is null).
 

The query is as follows.
 

SELECT *
FROM sysman.mgmt$metric_collection
ORDER BY target_name, target_type, metric_name;
 

The one field that throws me off is interval (polling frequency). Everything seems to be null, yet when I go into GC, I see that these are set to run anywhere from every 5 minutes to every 24 hours. It has to be set somewhere, but where? If I can find the table and then do a join, it will give me what I need.
 

Thanks!
 

Tom

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

Received on Mon Aug 31 2009 - 11:38:54 CDT