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

Thread: Mail or Beep Utilities

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi: If I am monitoring my DB and as an example, if I want to know when my datafile has reached a certain limit, or a dead lock happened etc., what is the best way to that? What is the procedure and what are the tools needed? Thanks

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    OEM (Oracle Enterprize Manager) has all that functionality built in though there are other 3rd party tools available as well.

    - Rajeev

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Oracle comes with a product called Oracle Enterprise Manager. You can purchase a "Module" for it that allows you to configure events as you specified. It will notify you by email or pager if an event occurs.
    Jeff Hunter

  4. #4
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    You can write your own scripts and using DBMS_PKGS you can have notification
    Thanks
    Kishore Kumar

  5. #5
    Join Date
    Oct 2000
    Posts
    449
    What about Unix ??
    We basically wanted to use it through the O/s..
    If I make it an OEM dependent, then I need a seperate DB for that to monitor and never to shut down right??

  6. #6
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    You do need another small database to keep the repository of the monitored databases. OEM can be instyalled on your workstation as it does not require much of space but you are right that you will have to keep it running all the time if you want to monitor your database constantly.
    In that case write your own scripts (use dbms_pkgs) and set the jobs in CRON to run repeatedly (or I think with DBMS_PKGS you don't even need cron scheduling).

    - Rajeev

  7. #7
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    Any body knows how to do it with script? Can I write a script and put it into cron job?

    Let me know.

    Thanks.

  8. #8
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    We have a script (called orawatch) that goes out and looks for different things that happen in the database. It runs every 5 minutes from a cron job. If it finds something that needs to be reported, it sends an email message to a group of pagers. Our Paging carrier has a feature that will convert an email message to an Alphanumeric page.

    It took about 6 weeks (on and off) to write the script that does something similar to OEM. You have to ask yourself if it is worthwile to write a program that comes with Oracle for free.
    Jeff Hunter

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