Scripts
Disable Temp and undo tablespace monitoring
User Rating: / 2
- Details
-
Parent Category: Articles
-
Created on Thursday, 13 October 2011 17:20
-
Last Updated on Monday, 12 March 2012 13:54
-
Published on Thursday, 13 October 2011 17:20
-
Hits: 4834
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