Re: Where are specific waits stored in GC repository?

Rich
 look in metric_daily or metric_hourly ... target name should be your db
target, target_type = 'database', metric_name = 'instance_efficiency' and
key_value like 'lib%' ... (check rest of key_values for more info)  then you
want info from  average/minimum/maximum/std_dev columns ...

metric_daily will contain data rolled up by day, metric_hourly will have
data rolled up by hour. Fastest access you will get into metric_Daily or
metric_hourly views is via target_guid .. which you can get by selecting
from mgmt_target view.

As for latch waits , you will probably find more info in AWR (as much as
contained in its history tables).

Raj

On Wed, May 5, 2010 at 12:57 PM, <lyallbarbour@xxxxxxxxxxxxxxx> wrote:

> 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.  :)
>
>
>

Other related posts: