http://www.forum.askdba.org/ Forum for Oracle DBA's en Sun, 12 Feb 2012 11:17:44 +0000 http://www.forum.askdba.org/topic/disabling-tablespace-threshold-alert-for-particular-tablespace#post-85 Thu, 10 Sep 2009 10:51:59 +0000 Amit Bansal 85@http://www.forum.askdba.org/ <p>To disable Threshold for tablespace (Percent type), use following statement</p> <pre> exec DBMS_SERVER_ALERT.SET_THRESHOLD( - metrics_id =&gt; DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL, - warning_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,- warning_value =&gt; '0', critical_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,- critical_value =&gt; '0', observation_period =&gt; 1,- consecutive_occurrences =&gt; 1, instance_name =&gt; NULL, - object_type =&gt; DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,- object_name =&gt; 'USERS'); </pre> <p>Replace tablespace USER with the tablespace you want to exclude from monitoring</p> <p>If you have also enabled tablespace alerts based on Bytes left, then use following</p> <pre> exec DBMS_SERVER_ALERT.SET_THRESHOLD( - metrics_id =&gt; DBMS_SERVER_ALERT.TABLESPACE_BYT_FREE, - warning_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK, - warning_value =&gt; '0', - critical_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK, - critical_value =&gt; '0', observation_period =&gt; 1, - consecutive_occurrences =&gt; 1, - instance_name =&gt; NULL, - object_type =&gt; DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE, - object_name =&gt; 'USERS'); </pre>