DECLARE
cursor lc1 is select tablespace_name from dba_tablespaces where contents != 'PERMANENT';
BEGIN
FOR i IN lc1 loop
BEGIN
dbms_server_alert.set_threshold (
dbms_server_alert.tablespace_pct_full,
dbms_server_alert.operator_do_not_check, '0',
dbms_server_alert.operator_do_not_check, '0', 1, 1, NULL,
dbms_server_alert.object_type_tablespace, i.tablespace_name);
END;
end loop;
END;
/
set pageisze 9999
set linesize 120
set numwidth 2
column metrics_name format a40
column object_name format a30
select metrics_name,
object_name,
warning_operator,
warning_value,
critical_operator,
critical_value
from dba_thresholds
where metrics_name = 'Tablespace Space Usage';
METRICS_NAME OBJECT_NAME WARNING_OPER
---------------------------------------- ------------------------------ ------------
WARNING_VALUE
------------------------------------------------------------------------------------------------------------------------
CRITICAL_OPE
------------
CRITICAL_VALUE
------------------------------------------------------------------------------------------------------------------------
Tablespace Space Usage TEMP DO NOT CHECK
0
DO_NOT_CHECK
0
Tablespace Space Usage UNDOTBS1 DO NOT CHECK
0
DO_NOT_CHECK
0
Tablespace Space Usage GE
85
GE
97