Oracle-L: RE: Root Cause Analysis White Papers

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 30 Apr 2002 08:31:28 -0800
Message-ID: <F001.004537EC.20020430083128@fatcity.com>

Peter - I can see your desires going in two directions:

Operational procedures - Things like "how do I know I'm running out of disk space before I've run out".
Change management. Most failures come from changes to the software. Like somebody adds some programs and that affects other programs. Or somebody changes a table and that affects another program.

For both of these, I wouldn't limit myself to sources specific to Oracle. Good standard I.S. procedures.

I haven't read it, but "Oracle 24x7 Tips and Techniques" by Venkat S. Devraj and Ravi Balwada looks as if it has some chapters that may be pertinent. Here is a link that might work, but will probably get chopped. http://shop.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=1G60ZMKA1J& mscssid=DDX7X88RWH4S9NNU2QH8344EP6QJ4VX7&isbn=0072119993

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, April 30, 2002 11:11 AM
To: Multiple recipients of list ORACLE-L

We have been having some heavy discussions about system failures, root cause analysis and developing some proactive metrics. Generally, our problems revolve around frequently late nights for the On Call DBA because something out of our control goes wrong. The damagement folks want to fix the immediate problem and consider the job done. The DBAs are asking for an approach that will allow us to identify potential problems before something breaks at 3:00 a.m.

Does anyone know of a source of white papers or other data that has been generated for systems, storage or databases? We can always roll out own, but why recreate someone else's work.

Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com

Do You Yahoo!?
Yahoo! Health - your guide to health and wellness http://health.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Peter Barnett
INET: regdba_at_yahoo.com

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: ListGuru_at_fatcity.com (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: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------