[Amit Bansal]

To disable Threshold for tablespace (Percent type), use following statement

<br />
exec  DBMS_SERVER_ALERT.SET_THRESHOLD( -<br />
metrics_id =&gt; DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL, -<br />
warning_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,-<br />
warning_value =&gt; '0',  critical_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,-<br />
critical_value =&gt; '0',  observation_period =&gt; 1,-<br />
consecutive_occurrences =&gt; 1,  instance_name =&gt; NULL, -<br />
object_type =&gt; DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE,-<br />
object_name =&gt; 'USERS');<br />

Replace tablespace USER with the tablespace you want to exclude from monitoring

If you have also enabled tablespace alerts based on Bytes left, then use following

<br />
exec  DBMS_SERVER_ALERT.SET_THRESHOLD(  -<br />
metrics_id =&gt; DBMS_SERVER_ALERT.TABLESPACE_BYT_FREE,  -<br />
warning_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,  -<br />
warning_value =&gt; '0', -<br />
critical_operator =&gt; DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK, -<br />
critical_value =&gt; '0',  observation_period =&gt; 1, -<br />
consecutive_occurrences =&gt; 1,  -<br />
instance_name =&gt; NULL, -<br />
object_type =&gt; DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE, -<br />
object_name =&gt; 'USERS');<br />

[Author]

Posts