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

On 14 Jul 2006 15:14:42 -0700, "Mark D Powell" <Mark.Powell_at_eds.com> 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.

Apart from that you can have http://www.oraperf.com , a site by Anjo Kolk, have the report analysed for you.

--
Sybrand Bakker, Senior Oracle DBA