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).
Re: Any scripts to check the health of the database
Do a search on Google -- you'll find plenty. -Joe --- Praveen Sahni [EMAIL PROTECTED] wrote: 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). __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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).
Re: Any scripts to check the health of the database
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).
RE: Any scripts to check the health of the database
sqlplus / as sysdba EOF select 'Database is healthy!!!' from dual; shutdown abort prompt 'Database needs Clarinex' EOF -Original Message- From: Praveen Sahni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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: Gogala, Mladen 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).
RE: Any scripts to check the health of the database
love it! - this gets my vote - -Original Message- Sent: Wednesday, April 24, 2002 4:58 PM To: Multiple recipients of list ORACLE-L sqlplus / as sysdba EOF select 'Database is healthy!!!' from dual; shutdown abort prompt 'Database needs Clarinex' EOF -Original Message- From: Praveen Sahni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 3:24 PM To: Multiple recipients of list ORACLE-L 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: Gogala, Mladen 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: Magaliff, Bill 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).
Re: Any scripts to check the health of the database
www.evdbt.com/library.htm has a health check script -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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).