I may be wrong but the first thing I got out of Carey and Jeff's book is = to ask the question, "Is anybody complaining?" I have long thought that = should be the primary indicator that something needs checked<g>. When I = look long enough, and hard enough, I will undoubtably find something = that needs to be messed with, often to my detriment. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Lord David Sent: Wednesday, August 25, 2004 8:33 AM To: 'oracle-l@xxxxxxxxxxxxx' Subject: d/b health check All, Can anyone point me to a good outline for a 'database health-check'. = I.e. is it best to base it on statspack/bstat/estat, some form of response = time breakdown (I'm reading Cary's book at the moment) or something else entirely. Regards -- David Lord Senior DBA Iron Mountain (UK) Ltd This email and its attachments are confidential under applicable law and = are intended for use of the sender's addressee only, unless the sender = expressly agrees otherwise, or unless a separate written agreement = exists between Iron Mountain and a recipient company governing = communications between the parties and any data that may be so = transmitted. Transmission of email over the Internet is not a secure = communications medium. If you are requesting or have requested the = transmittal of personal data, as defined in applicable privacy laws, by = means of email or in an attachment to email, you may wish to select a = more secure alternate means of transmittal that better supports your = obligations to protect such personal data. If the recipient of this message is not the recipient named above, = and/or you have received this email in error, you must take no action = based on the information in this email. You are hereby notified that = any dissemination, misuse or copying or disclosure of this communication = by a recipient who has received this message in error is strictly = prohibited. If this message is received in error, please return this = email to the sender and immediately highlight any error in transmittal. = Thank you. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------