Re: Where are specific waits stored in GC repository?
Date: Wed, 05 May 2010 12:57:31 -0400
Message-Id: <8CCBA8B2FDCF1B2-14AC-4496_at_web-mmc-d01.sysops.aol.com>
You can see it in Grid. Both with AWR and ADDM -- AND -- with the Historical view. Anything under Concurrency will show the latch waits. I don't understand why you are digging through the tables. :)
-----Original Message-----
From: Rich Jesse <rjoralist_at_society.servebeer.com>
To: oracle-l_at_freelists.org
Sent: Wed, May 5, 2010 12:22 pm
Subject: Where are specific waits stored in GC repository?
Howdy,
I'm attempting to determine how library cache latch waits may be impacting
s. I believe that the recent history of those waits is stored in the Grid
ontrol (10.2.0.3) repository DB, as I can drill down into it from GC's
erformance tab with the View Data dropdown set to "Historical".
I've looked through all the SYSMAN.MGMT$METRIC_% views, but can't seem to
ind specific wait types -- everything is listed by wait class. I thought
hat 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
ows on a spartan server, it's not going well... :)
Thoughts anyone? TIA!
Rich
--
ttp://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 05 2010 - 11:57:31 CDT