I haven't read the book, but it did occur that at the very least one thing
that coud be changed is the monitoring of the system in case it all goes
pear shaped again. I didn't explicitly say this and I should have
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Kenneth A Kauffman" <kkauffman_at_nospam.headfog.com> wrote in message
news:8KUra.77280$xB4.1894364_at_news2.east.cox.net...
>
> "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 - 15:05:20 CDT
