Re: SQL definition of grid metrics: where is it stored ?

Spendius wrote:
> I mean by "grid metrics" what we knew as "OEM events" in 8i/9i
> versions of Oracle. I actually found the directory in which
> all this stuff is kept, under sysman/admin/scripts... or
> something similar. They've switched from tcl scripts to perl
> scripts, but the SQL definition of events/metrics looks close
> to that of the previous versions.
>

>>What do you mean by "Grid metrics"? If you mean the metrics
>>reported in
>>the Grid Control they come from a large number of data
>>dictionary
>>objects. Far more than can be completely listed here.

The metrics for the GRID Control come from a very large number of objects. Among them:

v_$active_session_history

dba_advisor_journal
dba_advisor_objects
dba_advisor_parameters
dba_advisor_rationale
dba_advisor_recommendations
dba_advisor_sqlw_journal
dba_advisor_tasks
dba_advisor_usage
dba_hist_snapshot
dba_alert_history
dba_outstanding_alerts
dba_thresholds

and many many more.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)