tablespace custom alert thresholds reset to default values
We have some large tablespaces where I want to change the warning alert to 98% and the critical alert to 99%
I run the following
execute dbms_server_alert.set_threshold(9000,4,'98',4,'99',1,1,NULL,5,'TEST_TBS');
and check the following view which shows it has been set to my custom values
select * from SYS.WRI$_ALERT_THRESHOLD where T_METRICS_ID like '900%';
Within an hour this view only shows the database wide default values and this tablespace has been reset to 85% and 97%.
I can't see any jobs that are running at the same time it is reset. Any idea what's causing this?
I run the following
execute dbms_server_alert.set_threshold(9000,4,'98',4,'99',1,1,NULL,5,'TEST_TBS');
and check the following view which shows it has been set to my custom values
select * from SYS.WRI$_ALERT_THRESHOLD where T_METRICS_ID like '900%';
Within an hour this view only shows the database wide default values and this tablespace has been reset to 85% and 97%.
I can't see any jobs that are running at the same time it is reset. Any idea what's causing this?
0