DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: oracle8i table space issue

Hybrid View

  1. #1
    Join Date
    Feb 2006
    Posts
    34

    oracle8i table space issue

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    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.

  3. #3
    Join Date
    Feb 2003
    Location
    Leeds, UK
    Posts
    367
    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.

  4. #4
    Join Date
    Feb 2006
    Posts
    34
    thanks for hacketta1 & gandolf989. Now only i came to know that i can use 10g grid control to manage oracle8i database. thanks .

    Regards,
    Viji

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width