spacealert trigger

[girirajdba]

Hi ,
pls have a look at this
here is a procedure to alert the dba when a tablespace datafile is nearing its maxsize
would this work

create or replace procedure alrt_size (a out number(5))
is
begin
select sum(bytes) into a from dba_data_files;
if a:=90;
dbms_output.put_line('the datafile is nearing its maxsize');
fi
end;

[davey23uk]

how is that going to alert the dba? - where is dbms_output going to write to

[girirajdba]

well please tell me what should be used overthere instead of

dbms_output.put_line

[davey23uk]

well whatever program calls your procedure need to have something returned to it - so what is going to call your procedure?

[gandolf989]

Will any data file ever equal 90 bytes?????

[girirajdba]

Hi ,
forget abt the size thats just an example

just tell me if the procedure & logic is right

or

is there any other way to do this alert

[LKBrwn_DBA]

Maybe you should check DBA_FREE_SPACE instead and send an e-mail with UTL_SMTP when free space < 10% of DBA_DATA_FILES.

[davey23uk]

there is nothing right about it.

You know there are many tools freely available which do this for you