Received: (qmail 8605 invoked from network); 7 Jul 2011 08:30:12 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 7 Jul 2011 08:29:52 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0E705E32BF7; Thu, 7 Jul 2011 09:26:48 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FPoeEj7kkkeN; Thu, 7 Jul 2011 09:26:47 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8AD02E32AF3; Thu, 7 Jul 2011 09:26:04 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 07 Jul 2011 09:25:22 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2115E32B70 for ; Thu, 7 Jul 2011 09:25:21 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id kKkbGUXaTJua for ; Thu, 7 Jul 2011 09:25:21 -0400 (EDT) Received: from mail-fx0-f47.google.com (mail-fx0-f47.google.com [209.85.161.47]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 86064E32B20 for ; Thu, 7 Jul 2011 09:25:09 -0400 (EDT) Received: by fxg11 with SMTP id 11so1239184fxg.34 for ; Thu, 07 Jul 2011 06:25:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=Qs8uR9JJ0My4BQOd+GYIq7koOdrLBP+d2Z754drC5mU=; b=WnoNTlSc9StxC/WZS1b1bekwAnxFH6Ww8tg3kvgzg1IF68XLiCudcMbOjV9/0j+uwI LZGhCtWGceqdBsYJql2kJWY5jfJkrAgSp3Ml+8qTfE4KJa8r5gTKW/E8VfkCPwUi9lBs YAREJZSMgOtkRwimF8yFyjGniWnm5Wpz1W6x8= MIME-Version: 1.0 Received: by 10.223.13.13 with SMTP id z13mr1254718faz.114.1310045086102; Thu, 07 Jul 2011 06:24:46 -0700 (PDT) Received: by 10.223.70.208 with HTTP; Thu, 7 Jul 2011 06:24:46 -0700 (PDT) In-Reply-To: References: <4814386347E41145AAE79139EAA39898150683D396@ws03-exch07.iconos.be> Date: Thu, 7 Jul 2011 14:24:46 +0100 Message-ID: Subject: Re: shared pool notifications From: Niall Litchfield To: pdba1966@hotmail.com Cc: cicciuxdba@gmail.com, oracle-l@freelists.org Content-Type: multipart/alternative; boundary=20cf3054a287ff33a504a77aa32d X-archive-position: 37279 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: niall.litchfield@gmail.com Precedence: normal Reply-To: niall.litchfield@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --20cf3054a287ff33a504a77aa32d Content-Type: text/plain; charset=ISO-8859-1 Hi Largely, I think, because of licensing rules Oracle Database implements a distinction between an alert and a notification. In Oracle RDBMS terms a server alert occurs whenever a threshold for a metric is passed. The term alert doesn't carry its normal english interpretation of a warning to anybody, it's just recording the occurrence of an event of interest. This functionality is free - or rather part of your database license. Telling someone about this event - say by email - is a notification and requires a management pack to be licensed - unless you just code based on DBA_OUTSTANDING_ALERTS and UTL_MAIL :) . Monitoring Templates define your critical and warning threshold values - consequently they effectively define when a server alert will occur for a specific metric. Their great advantage (at least since GC 10.2.0.5 ) is that you can define a policy across an enterprise for targets of a specific type and apply the same threshold rules to all of them once. Doing this says nothing about who will receive emails etc. It purely controls the point at which you become interested in a metric's value (or cease to be interested in it). Notification rules allow administrators to subscribe to server generated alerts in which they are interested - for example you might have a team that handles database storage that would be interested in disk space, tablespace etc alerts and another that was interested in performance metrics. Alternatively you might subscribe based on role of the target (dev/prod etc). As for what suitable metrics are for SHARED_POOL usage I suspect that to be hugely application specific and so probably not suitable for either templating or internet advice :( Niall On Thu, Jul 7, 2011 at 1:40 AM, P D wrote: > What do you think is a good setting to use in Grid Control for 'Warning' > and 'Critical' for Shared Pool? I am just learning Grid Control and > trying to set it up now which brings up the next question. What is the > difference between Preferences->Notification Rule and Setup->Monitoring > Templates? > > In creating Monitoring templates, you have to select all the metric and > also, while creating notification rule, you have to once again select the > metrics. Getting confused at what is the difference between the two. > > ------------------------------ > Date: Tue, 5 Jul 2011 13:11:00 -0300 > Subject: Re: shared pool notifications > From: cicciuxdba@gmail.com > > To: Freek.DHooge@uptime.be > CC: pdba1966@hotmail.com; oracle-l@freelists.org > > > do you have grid control? > Alan.- > > > Is there a way to get notified that the shared pool is running out of > memory before it actually occurs? > > We had a sudden unexpected spike of activity and the database was unable to > allocate shared memory. This is a 10.2.0.4 database. We saw it in the > alert log but only after it had run out. Just wondering what other people > are doing as far as receiving notifications before it runs completely out. > -- > http://www.freelists.org/webpage/oracle-l > > > > -- Niall Litchfield Oracle DBA http://www.orawin.info --20cf3054a287ff33a504a77aa32d Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi

Largely, I think, because of licensing rules Oracle D= atabase implements a distinction between an alert and a notification. In Or= acle RDBMS terms a server alert occurs whenever a threshold for a metric is= passed. The term alert doesn't carry its normal english interpretation= of a warning to anybody, it's just recording the occurrence of an even= t of interest. This functionality is free - or rather part of your database= license. Telling someone about this event - say by email - is a notificati= on and requires a management pack to be licensed - unless you just code bas= ed on DBA_OUTSTANDING_ALERTS and UTL_MAIL :) .=A0

Monitoring Templates define your critical and warning t= hreshold values - consequently they effectively define when a server alert = will occur for a specific metric. Their great advantage (at least since GC = 10.2.0.5 ) is that you can define a policy across an enterprise for targets= of a specific type and apply the same threshold rules to all of them once.= Doing this says nothing about who will receive emails etc. It purely contr= ols the point at which you become interested in a metric's value (or ce= ase to be interested in it).=A0

Notification rules allow administrators to subscribe to= server generated alerts in which they are interested - for example you mig= ht have a team that handles database storage that would be interested in di= sk space, tablespace etc alerts and another that was interested in performa= nce metrics. Alternatively you might subscribe based on role of the target = (dev/prod etc).=A0

As for what suitable metrics are for SHARED_POOL usage = I suspect that to be hugely application specific and so probably not suitab= le for either templating or internet advice :(=A0


Niall
=A0

On Thu= , Jul 7, 2011 at 1:40 AM, P D <pdba1966@hotmail.com> wrote:
What do you think is a good setting to use in Grid Control for=A0'Warni= ng' and 'Critical' for Shared Pool?=A0=A0=A0 I am just learning= =A0Grid Control and trying to set it up now which brings up the next questi= on.=A0=A0=A0=A0What is the difference between Preferences->Notification = Rule and Setup->Monitoring Templates?

In creating Monitoring templates, you have to select all the metric and= also, while creating notification rule, you have to once again select the = metrics.=A0=A0=A0=A0Getting confused at what is the difference between the = two.
=A0
Date: Tue, 5 Jul 2011 13:11:00 -0300
Subject: Re: shared pool notificati= ons
From: cicc= iuxdba@gmail.com

To: Freek.DHooge@uptime.be
CC: pdba196= 6@hotmail.com; oracle-l@freelists.org


do you have grid co= ntrol?
Alan.-


Is there a way to get notified that the shared p= ool is running out of memory before it actually occurs?
=A0
We had a = sudden unexpected spike of activity and the database was unable to allocate= shared memory.=A0=A0=A0=A0 This is a 10.2.0.4 database.=A0=A0=A0 We saw it= in the alert log but only after it had run out.=A0=A0 Just wondering what = other people are doing as far as receiving notifications before it runs com= pletely out.
--
http://www= .freelists.org/webpage/oracle-l






--
Niall Litchfield
Ora= cle DBA
http://www.orawin.info
--20cf3054a287ff33a504a77aa32d-- -- http://www.freelists.org/webpage/oracle-l