8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: ts_thresholds_set_default.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/ts_thresholds_set_default.sql -- Author : Tim Hall -- Description : Displays threshold information for tablespaces. -- Call Syntax : @ts_thresholds_set_default (warning) (critical) -- Last Modified: 13/02/2014 - Created -- ----------------------------------------------------------------------------------- SET VERIFY OFF DECLARE l_warning VARCHAR2(2) := '&1'; l_critical VARCHAR2(2) := '&2'; BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD( metrics_id => DBMS_SERVER_ALERT.TABLESPACE_PCT_FULL, warning_operator => DBMS_SERVER_ALERT.OPERATOR_GE, warning_value => l_warning, critical_operator => DBMS_SERVER_ALERT.OPERATOR_GE, critical_value => l_critical, observation_period => 1, consecutive_occurrences => 1, instance_name => NULL, object_type => DBMS_SERVER_ALERT.OBJECT_TYPE_TABLESPACE, object_name => NULL); END; / SET VERIFY ON