28 | 03 | 2024
Latest Articles
Popular Articles

Scripts

Disable Temp and undo tablespace monitoring

User Rating:  / 2
PoorBest 

Disable Temp & Undo Tablespace monitoring using dbms_server_alert.

 

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