Disabling Tablespace threshold alert for particular tablespace

AskDBA.org Forum » DBA - Wiki

Disabling Tablespace threshold alert for particular tablespace

(1 post)

Average Rating For This Topic:

Rate This Topic Yourself:

Started 10 months ago by Amit Bansal

Tags:

Amit Bansal

Oracle DBA
Joined: Jun '08
Posts: 44

offline

Reputation:57

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');

AskDBA.org Forum

Subscribe to aSkDba.org Forum Posts

AskDBA.org Forum » DBA - Wiki

Disabling Tablespace threshold alert for particular tablespace

Reply