oracle8i table space issue

[vijill]

If the table space is 20% free, send alert to lotus email.if it is 5% free, send alert to mobile number. how do we do this. If u have any idea, please let me know.

Regards

[gandolf989]

Have you looked at using OEM for alerts? You can also write your own with the system packages. Or you can buy something from Quest, CA or many other vendors.

[hacketta1]

Sending email can be done via PL/SQL (http://asktom.oracle.com/pls/ask/f?p...D:255615160805) or a Unix shell script using the mailx command. To send a text message to a mobile you will need some purpose built software; I use telalert (http://www.calamp.com/pro_telalert_ums.html).

Here is an example shell script that will email you when tablespace usage exceeds 90%. Perhaps you can modify it for your needs.

Oracle Grid Control 10g will monitor tablespace usage and send you an email out of the box. Monitoring 8i databases using 10g Grid Control is supported.

[vijill]

thanks for hacketta1 & gandolf989. Now only i came to know that i can use 10g grid control to manage oracle8i database. thanks .

Regards,
Viji