Re: Root Cause Analysis White Papers

• Peter Barnett <regdba_at_yahoo.com>

> 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.

See the Usenix doc's on Auditing, sys-admin skills for examples. LISA papers also have covered audit procedures.

What you are really asking for is a system audit. The results from a full audit would be a good place to start looking at what is done on the systems, what goes wrong with them and where to look further for root causes. Audit results also give you the facts you'll need in convincing the manglement that something really is wrong and it needs fixing.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steven Lembark
  INET: lembark_at_wrkhors.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).