Re: Oracle 11g is it possible to set adaptive threshold for repeating AWR base lines
From: ddf <oratune_at_msn.com>
Date: Tue, 5 Jan 2010 04:53:56 -0800 (PST)
Message-ID: <aa5c5d00-3a73-41c8-9b0c-13e647d3c07b_at_m25g2000yqc.googlegroups.com>
On Jan 1, 11:03 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> On Jan 1, 10:20 am, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On Dec 31 2009, 2:41 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
> > > I am on Oracle 11g Release 1 (11.1.0.7.1). Oracle 11g provides
> > > adapting threshold for SYSTEM_MOVING_WINDOW AWR Baseline. However, I
> > > want to set these threshold for my own AWR Baseline.
>
> > > I defined a repeating AWR Base Line. It is not clear reading the
> > > documentation whether repeating AWR base line works like
> > > SYSTEM_MOVING_WINDOW. i.e., metrics of today Monday at 1:00PM will be
> > > compared with last week’s metric (last Monday at 1:00PM). If not what
> > > is the purpose of repeating AWR baseline.
>
> > > I went to Baseline Metrics Threshold, I set thresholds on Average
> > > Active Session using Significance Levels, it let me specify
> > > significance for Critical and Warning, but I do not find Threshold to
> > > be Adaptive. If I chose same metric and set same significance values
> > > for SYSTEM_MOVING_WINDOW adaptive threshold is set.
>
> > > So I am confused on the purpose of repeating AWR baseline.
>
> > A repeating baseline is recalculated at the specified interval for the
> > specified window. For example you set a repeating baseline for
> > Tuesdays between 6:00 AM and 8:30 AM. So every Tuesday at 6:00 AM a
> > new AWR baseline is generated from statistics and data gathered until
> > 8:30 AM that morning. You now have a current baseline with which to
> > compare the rest of the week's workload statistics and data. Each
> > Tuesday you get a NEW baseline. You really should read here:
>
> >http://download.oracle.com/docs/cd/B28359_01/server.111/b28275/tdppt_...
>
> > as it explains how repeating baselines are generated.
>
> > David Fitzjarrell- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks, I had read the documentation. Why then there are no adaptive
> threshholds for repeating baseline (in datbase control, adaptive
> threshold remains blank unlike SYSTEM_MOVING_WINDOW).- Hide quoted text -
>
> - Show quoted text -
Date: Tue, 5 Jan 2010 04:53:56 -0800 (PST)
Message-ID: <aa5c5d00-3a73-41c8-9b0c-13e647d3c07b_at_m25g2000yqc.googlegroups.com>
On Jan 1, 11:03 am, zigzagdna <zigzag..._at_yahoo.com> wrote:
> On Jan 1, 10:20 am, ddf <orat..._at_msn.com> wrote:
>
>
>
>
>
> > On Dec 31 2009, 2:41 pm, zigzagdna <zigzag..._at_yahoo.com> wrote:
>
> > > I am on Oracle 11g Release 1 (11.1.0.7.1). Oracle 11g provides
> > > adapting threshold for SYSTEM_MOVING_WINDOW AWR Baseline. However, I
> > > want to set these threshold for my own AWR Baseline.
>
> > > I defined a repeating AWR Base Line. It is not clear reading the
> > > documentation whether repeating AWR base line works like
> > > SYSTEM_MOVING_WINDOW. i.e., metrics of today Monday at 1:00PM will be
> > > compared with last week’s metric (last Monday at 1:00PM). If not what
> > > is the purpose of repeating AWR baseline.
>
> > > I went to Baseline Metrics Threshold, I set thresholds on Average
> > > Active Session using Significance Levels, it let me specify
> > > significance for Critical and Warning, but I do not find Threshold to
> > > be Adaptive. If I chose same metric and set same significance values
> > > for SYSTEM_MOVING_WINDOW adaptive threshold is set.
>
> > > So I am confused on the purpose of repeating AWR baseline.
>
> > A repeating baseline is recalculated at the specified interval for the
> > specified window. For example you set a repeating baseline for
> > Tuesdays between 6:00 AM and 8:30 AM. So every Tuesday at 6:00 AM a
> > new AWR baseline is generated from statistics and data gathered until
> > 8:30 AM that morning. You now have a current baseline with which to
> > compare the rest of the week's workload statistics and data. Each
> > Tuesday you get a NEW baseline. You really should read here:
>
> >http://download.oracle.com/docs/cd/B28359_01/server.111/b28275/tdppt_...
>
> > as it explains how repeating baselines are generated.
>
> > David Fitzjarrell- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks, I had read the documentation. Why then there are no adaptive
> threshholds for repeating baseline (in datbase control, adaptive
> threshold remains blank unlike SYSTEM_MOVING_WINDOW).- Hide quoted text -
>
> - Show quoted text -
If you're changing the baseline on a scheduled basis why have an 'adaptive threshold'? You're trying to hit a moving target.
David Fitzjarrell Received on Tue Jan 05 2010 - 06:53:56 CST