I believe that the historical data that you see is derived from AWR tables (dba_hist_* tables) in the monitored database and not from GC's repository. The mgmt$metric_* views are for metric details and I haven't seen metrics related to specific wait events in GC.
Harel Safra On 05/05/2010 19:22, Rich Jesse wrote:
Howdy, I'm attempting to determine how library cache latch waits may be impacting us. I believe that the recent history of those waits is stored in the Grid Control (10.2.0.3) repository DB, as I can drill down into it from GC's Performance tab with the View Data dropdown set to "Historical". I've looked through all the SYSMAN.MGMT$METRIC_% views, but can't seem to find specific wait types -- everything is listed by wait class. I thought that the MGMT$METRIC_DETAILS view would be the one, but not that I can see. I'm attempting to browse the MGMT_METRICS_RAW table directly, but with>10M rows on a spartan server, it's not going well... :) Thoughts anyone? TIA! Rich -- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l