Re: dbms_server_alert.tablespace_byt_free measures really KB?

From: ddf <oratune_at_msn.com>
Date: Thu, 10 Feb 2011 07:35:34 -0800 (PST)
Message-ID: <5fe4961e-bbb1-48da-96b9-f700e434435a_at_o7g2000prn.googlegroups.com>



On Feb 10, 9:27 am, Lothar Armbrüster
<l.armbrues..._at_vertriebsunion.de> wrote:
> 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:
>
> begin
>    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.
>
> Regards,
> Lothar

IF possible, set up a 'dummy' tablespace with less than 1 GB of storage then redirect your alert to this tablespace and see what happens with your various configuration settings. It would appear that the documentation is incorrect, however you won't know that for certain until you test this with a tablespace known to have less than 1 GB free.

David Fitzjarrell Received on Thu Feb 10 2011 - 09:35:34 CST

Original text of this message