Re: How long should statspack.snap take to run?

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 15 Jul 2006 08:03:00 -0700
Message-ID: <1152975780.673522.158740@i42g2000cwa.googlegroups.com>

hpuxrac wrote:
> Mark D Powell wrote:
> >
> > Statspack can be a very useful took IF you work with it enough to
> > understand what it shows you. While the default report has limited
> > usefulness for finding specific causes of performance problems the
> > report can identify if the database as a whole had a performance
> > problem. Higher level settings can be used to help locate resource
> > intensive SQL, which generally sits at the bottom of all performance
> > problems.
>
> Resource intensive SQL which "sits at the bottom"?
>
> I think you mean the top.

That statement threw me at first too.

I think that his use of "bottom" relates to those types of SQL statements being the under-lying cause of the problem, at the root of the problem. This is kind of like the use of the word "Fundamentals" in the book title by Jonathan Lewis, which in that case seems to mean the low level workings of the item being examined.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Sat Jul 15 2006 - 10:03:00 CDT