How do I clear a threshold
Hello
For some test purposes I defined a a new tablespace threashold for a specific tablespace.
exec dbms_server_alert.set_threshold(
metrics_id => dbms_server_alert.tablespace_pct_full,
warning_operator => dbms_server_alert.operator_gt,
warning_value => 60,
critical_operator => dbms_server_alert.operator_gt,
critical_value => '95',
observation_period => 1,
consecutive_occurrences => 1,
instance_name => null,
object_type => dbms_server_alert.object_type_tablespace,
object_name => 'XN_TSP01L');
/
Because of firewalls, etc I cannot change/delete the threshold via Grid and I need to remove this threshold manually in SQL*Plus. If I set the value for warning and critical to 0 the tablespace won't be monitored. I really need to don't see the information for this tablespace in the view DBA_THRESHOLDS.
Any ideas about how to do that?
Thanks
Aron