Disabling Tablespace threshold alert for particular tablespace

Home Forums DBA – Wiki Disabling Tablespace threshold alert for particular tablespace

This topic contains 0 replies, has 0 voices, and was last updated by  Amit Bansal 8 years, 1 month ago.

  • Author
    Posts
  • #1899

    Amit Bansal
    Keymaster

    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 />
    

You must be logged in to reply to this topic.