Originally posted by r_sonakiya
sambavan and Julian...Could you please write some details,examples etc..

Thanks
How often do you need to check for how much space you have left?

This will start a job every morning at 5AM and will send you email:

Code:
variable jobno number; 
begin 
dbms_job.submit(:jobno,'sp_r_sonakiya;',trunc(sysdate) + 5/24,
'trunc(sysdate+1) + 5/24'); 
COMMIT; 
end; 
/
where sp_r_sonakiya is a stored procedure that checks bytes/maxbytes from dba_data_files and sends you email if, say, space left is < 10%.

Do you know how to write that procedure and moreover, do you have a procedure that sends email?

Make a serach in the forum with keyword send_email and you will hit the right code.