Re: How to switch off UNDOTBS01 alerts for multiple databases

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