AskDBA.org Forum Forum for Oracle DBA's

About This Topic

• Posted 2 years ago
• By Amit Bansal
• Latest reply from Amit Bansal
• This topic is not a support question
• RSS feed for this topic

Tags

• DBMS_SERVER_ALERT
• Threshholds

1. 

   Amit Bansal
   

   Oracle DBA
   Joined: Jun '08
   Posts: 73

   offline

   Reputation:96

    

   
   Posted 2 years ago
   #

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

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

   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

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

   Cheers
   Amit
   http://askdba.org/weblog/