Re: AWR report generator for past periods (with graphs)?
From: kyle Hailey <kylelf_at_gmail.com>
Date: Fri, 7 Sep 2012 08:58:02 -0700
Message-ID: <CADsdiQjxXWULAXqV0D-WeX3ga3LhMkMGgfHmrqR+J2mOFoRPLg_at_mail.gmail.com>
>> You are right, ASH probably misses some critical waits.
How would ASH miss critical waits?
Can you come up with an example where ASH was missing "critical" wait information but v$system_event ( DBA_HIST_SYSTEM_EVENT) had it?
Date: Fri, 7 Sep 2012 08:58:02 -0700
Message-ID: <CADsdiQjxXWULAXqV0D-WeX3ga3LhMkMGgfHmrqR+J2mOFoRPLg_at_mail.gmail.com>
>> You are right, ASH probably misses some critical waits.
How would ASH miss critical waits?
Can you come up with an example where ASH was missing "critical" wait information but v$system_event ( DBA_HIST_SYSTEM_EVENT) had it?
- Kyle
On Fri, Sep 7, 2012 at 12:31 AM, Ls Cheng <exriscer_at_gmail.com> wrote:
> Hi Petr
>
> You are right, ASH probably misses some critical waits.
>
> I do have another script though, usually I run both scripts, one to get
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Sep 07 2012 - 10:58:02 CDT