You can send e-mails using UTL_TCP and UTL_SMTP, see MetaLink for example.
Alternatively you can run crontab for Windows or AT jobs regularly and use
something like blat to send alerts when certain conditions occur.
You have to maintain the scripts though. Scripting on NT / Win2K is (er...)
disingenuous.
For example you can use freeware utilities like grade to compare the length
of files.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst�mes
Technology Services | Services technologiques
Informatics Branch | Direction de l'informatique
Maritimes Region, DFO | R�gion des Maritimes, MPO
E-Mail: [EMAIL PROTECTED]
-----Original Message-----
Sent: Thursday, April 25, 2002 8:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Any scripts to check the health of the database
This is something that I am looking for a way to check on an 8.1.7 database
running on NT without me physically having to login myself. Is there some
automated way to do this, that maybe can send an email to a computer
operator??
Thanks,
Dave
-----Original Message-----
Sent: Wednesday, April 24, 2002 4:13 PM
To: Multiple recipients of list ORACLE-L
Personally, I think that many folks go a bit overboard when
it comes to checking the health of a database.
These are the things I like to check for:
* is the database up? this is the most important tech check
* status of jobs in DBA_JOBS
* space issues. Will a table be able to extend N times
without error?
* are the users happy? This is actually more important
than any of the technical issues.
There's a lot of other things you can check, but personnaly, I
quit checking them long ago.
I do log a few things from the database, and periodically store
the explain plans for SQLin the cache for troubleshooting later
the things go awry. This is really not part of a periodic
health check though, this is a whole different matter.
One thing to keep in mind: Rolling your own helps you to
understand what's being monitored. :)
Jared
Praveen Sahni <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
04/24/2002 12:24 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Any scripts to check the health of the database
Hi All,
I need to write a report on the health of a database.
Please send if any of us have a scripts and any report format for the
health
of the database.
Thanks in advance
Praveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Praveen Sahni
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Boivin, Patrice J
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
