dbms_server_alert.tablespace_byt_free measures really KB?
Date: Thu, 10 Feb 2011 07:27:08 -0800 (PST)
Hello out there,
I tried to configure alerts for full tablespaces using dbms_server_alert.set_threshold. Since we do not have licensed diagnostics pack I cannot do this with dbconsole. I have to resort to the command line.
Anyway, I want to get a warning when the tablespace has less than 1GB free space.
So I issued the following command:
dbms_server_alert.set_threshold(metrics_id => dbms_server_alert.tablespace_byt_free,
warning_operator => dbms_server_alert.operator_le, warning_value => '1048576', critical_operator => dbms_server_alert.operator_le, critical_value => '204800', observation_period => 1, consecutive_occurrences => 1, instance_name => null, object_type => dbms_server_alert.object_type_tablespace, object_name => 'TS_TABLES');end;
But now I get a critical warning saying tablespace TS_TABLES only has
8505 MB free space left.
Therefor the question is: are the units of dbms_server_alert.tablespace_byt_free really KB as described in the documentation or are this MB as I suspect? Setting the thresholds to 1024 and 200 the alerts disappear but I want to be sure that I get warnings if there are fewer than 1GB left and not fewer than 1MB. In the latter case there would not be enough time to react. :-)
This is Oracle 10.2.0.5 on Windows 2000.
Lothar Received on Thu Feb 10 2011 - 09:27:08 CST