Re: Boss is asking for 'root cause analysis'

"Ed Stevens" <nospam_at_noway.nohow> wrote in message news:bbsvavoe46gl1rkd0q0pps8kqkadbm5l83_at_4ax.com...
> On Wed, 30 Apr 2003 15:29:20 +0100, "Niall Litchfield"
> <n-litchfield_at_audit-commission.gov.uk> wrote:
>
> >Unless you have some sort of performance monitoring data, I suspect that
> >finding the root cause will be impossible.
> >
> >If you have , say, statspack or ultbstat/utlestat reports covering the
> >relevant period, or explain plans for the problem queries before and
after
> >it will be pretty difficult to see what was going on.
> >
> >I'd strongly suspect the dataload causing the access plans to become
> >inappropriate but without seeing the access plans it is pretty well
> >impossible to tell.
> >
> >The other question to ask is wether the reporting tools/queries had been
> >changed/upgraded in anyway.
>
>
> Niall,
>
> Thanks for the reply. You add weight to what I already suspected.
> From my end, I assume that I don't know what it is that I don't know,
> so am always looking for confirmation or refutation. This whole app
> has been a severly underfunded disaster waiting to happen.
>

ISBN: 007222360X
Oracle9i High-Performance Tuning with STATSPACK

Fairly decent book and also explains how to automate capturing statistics on a scheduled basis, including system resources.

ken k Received on Wed Apr 30 2003 - 13:37:56 CDT