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

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 15 Jul 2006 06:50:40 -0700
Message-ID: <1152971440.313188.150840@75g2000cwc.googlegroups.com>

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. Received on Sat Jul 15 2006 - 08:50:40 CDT