Where are specific waits stored in GC repository?
- From: "Rich Jesse" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 5 May 2010 11:22:45 -0500 (CDT)
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
Other related posts:
