DBMS_SERVER_ALERT package
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.
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.
0