Re: Grid Control Metrics Report
From: Rich Jesse <rjoralist_at_society.servebeer.com>
Date: Mon, 31 Aug 2009 11:47:10 -0500 (CDT)
Message-ID: <0f2c91db40fd2c293d8ea0108a1bca12.squirrel_at_society.servebeer.com>
Hey Tom,
Date: Mon, 31 Aug 2009 11:47:10 -0500 (CDT)
Message-ID: <0f2c91db40fd2c293d8ea0108a1bca12.squirrel_at_society.servebeer.com>
Hey Tom,
If you look at the source of that view, you'll see that the COLLECTION_FREQUENCY column is hard-coded to be NULL. Not sure why, but it is.
Perhaps the XML-like SCHEDULE_EX column from the similarly-named MGMT_METRIC_COLLECTIONS view might help you?
Rich
> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 31 2009 - 11:47:10 CDT