Re: Boss is asking for 'root cause analysis'

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. Received on Wed Apr 30 2003 - 10:56:38 CDT