Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!u41g2000yqe.googlegroups.com!not-for-mail
From: zigzagdna <zigzagdna@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Oracle 11g is it possible to set adaptive threshold for repeating 
 AWR base lines
Date: Fri, 1 Jan 2010 08:03:51 -0800 (PST)
Organization: http://groups.google.com
Lines: 44
Message-ID: <c62130b7-ff73-4f7e-ab52-fa525aa7bc02@u41g2000yqe.googlegroups.com>
References: <f137cbfd-8a78-41eb-b36f-ead63c36ee6e@a15g2000yqm.googlegroups.com> 
 <2fdbce50-61be-4a3f-b3bc-709ef50778cf@h9g2000yqa.googlegroups.com>
NNTP-Posting-Host: 148.177.1.210
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1262361831 13036 127.0.0.1 (1 Jan 2010 16:03:51 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 1 Jan 2010 16:03:51 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u41g2000yqe.googlegroups.com; posting-host=148.177.1.210; 
 posting-account=PUA9dQoAAAAWB6fqjaJDJmTx7eb4x-f4
User-Agent: G2/1.0
X-HTTP-Via: 1.1 Application and Content Networking System Software 5.5.11
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET 
 CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2; .NET 
 CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET CLR 1.1.4322; MS-RTC LM 
 8),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Jan 1, 10:20=A0am, ddf <orat...@msn.com> wrote:
> On Dec 31 2009, 2:41=A0pm, zigzagdna <zigzag...@yahoo.com> wrote:
>
>
>
>
>
> > I am on Oracle 11g Release 1 (11.1.0.7.1). Oracle 11g provides
> > adapting threshold for =A0SYSTEM_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=92s 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. =A0For example you set a repeating baseline for
> Tuesdays between 6:00 AM and 8:30 AM. =A0So every Tuesday at 6:00 AM a
> new AWR baseline is generated from statistics and data gathered until
> 8:30 AM that morning. =A0You now have a current baseline with which to
> compare the rest of the week's workload statistics and data. =A0Each
> Tuesday you get a NEW baseline. =A0You 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).