Database Administration (MOSC)

MOSC Banner

DBMS_SERVER_ALERT package

edited Jun 12, 2009 6:40AM in Database Administration (MOSC) 2 commentsAnswered
 Hi,

Last couple of days i have been working on the inbuilt package DBMS_SERVER_ALERT which has led to a couple of question. Please take my below example as a reference to the question that i have asked below.


DBMS_SERVER_ALERT.set_threshold
                                    (metrics_id                   => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL,
                                     warning_operator             => DBMS_SERVER_ALERT.OPERATOR_GE,
                                     warning_value                => 85,
                                     critical_operator            => DBMS_SERVER_ALERT.OPERATOR_GE,
                                     critical_value               => 97,
                                     observation_period           => 30,
                                     consecutive_occurrences      => 1,
                                     instance_name                => '',
                                     object_type                  => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,
                                     object_name                  => 'DBADAT01'
                                    );


1. The above example works prefectly well to enable any server alert with various metric ID , but When i try to disable alert with the operator DBMS_SERVER_ALERT.operator_do_not_check for any alert with object type not falling into OBJECT_TYPE_TABLESPACE it errors out stating invalid warning operator. Some information in the net showed me that this operator only supports object_type of OBJECT_TYPE_TABLESPACE , which i don't agree fully since there need to be way to disable  it . so my question here is does any one know how to disable alert which has object type of OBJECT_TYPE_SYSTEM , OBJECT_TYPE_SESSION etc.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center