Re: How to switch off UNDOTBS01 alerts for multiple databases
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 28 Nov 2011 07:21:53 +0000
Message-ID: <CABe10sZ-oZKdfjMPOmum559=38rSvB2z7HRmpw7fbFYyLDcBBg_at_mail.gmail.com>
It's worth also remarking upon the monitoring template and notification rules and subscription functionality that is available in Grid Control. The former allows you to configure a standard set of alert thresholds and apply them across your estate, the latter allows you to classify alerts with more granularity than a simple warning/critical level and also of course to route calls appropriately (for example if you repeatedly run out of temp or undo you probably do want to know about it, but not necessarily at 3 in the morning)
On Nov 27, 2011 10:35 PM, "Tony Adolph" <tony.adolph.dba_at_gmail.com> wrote:
> Hi all,
> Thanks for the feedback Greg and Faud,
>
> I noticed the feedback was not going to all on the list, so I thought I'd
> fwd it all:
>
> There's a job in the Job Library (in Grid): "DISABLE TABLESPACE USED (%)
> ALERTS FOR UNDO AND TEMP TABLESPACES" that's been setup to satisfy my
> requirement for UNDO and TEMP.
>
> Plus, ML Note: *How to - Exclude UNDO and TEMP Tablespaces From The
> Tablespace Used (%) Metric [ID 816920.1] discusses the same and hints at
> how to switch off alerting for other tablespaces using
> *DBMS_SERVER_ALERT.SET_THRESHOLD()
>
> So exactly what I was after,
>
> Thanks
> Tony*
>
>
> *
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
Date: Mon, 28 Nov 2011 07:21:53 +0000
Message-ID: <CABe10sZ-oZKdfjMPOmum559=38rSvB2z7HRmpw7fbFYyLDcBBg_at_mail.gmail.com>
It's worth also remarking upon the monitoring template and notification rules and subscription functionality that is available in Grid Control. The former allows you to configure a standard set of alert thresholds and apply them across your estate, the latter allows you to classify alerts with more granularity than a simple warning/critical level and also of course to route calls appropriately (for example if you repeatedly run out of temp or undo you probably do want to know about it, but not necessarily at 3 in the morning)
On Nov 27, 2011 10:35 PM, "Tony Adolph" <tony.adolph.dba_at_gmail.com> wrote:
> Hi all,
> Thanks for the feedback Greg and Faud,
>
> I noticed the feedback was not going to all on the list, so I thought I'd
> fwd it all:
>
> There's a job in the Job Library (in Grid): "DISABLE TABLESPACE USED (%)
> ALERTS FOR UNDO AND TEMP TABLESPACES" that's been setup to satisfy my
> requirement for UNDO and TEMP.
>
> Plus, ML Note: *How to - Exclude UNDO and TEMP Tablespaces From The
> Tablespace Used (%) Metric [ID 816920.1] discusses the same and hints at
> how to switch off alerting for other tablespaces using
> *DBMS_SERVER_ALERT.SET_THRESHOLD()
>
> So exactly what I was after,
>
> Thanks
> Tony*
>
>
> *
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 28 2011 - 01:21:53 CST