Re: How to capture information to analyze high load peak?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 08 Sep 2005 23:20:26 GMT
Message-ID: <_G3Ue.85653$Hx4.44724@twister.nyroc.rr.com>

Noons wrote:
>
>
> One more quick thing:
> if you run statspack frequently and you have a busy system with lots
> and lots of concurrent SQL, watch out for disk space use.
> The default cleanup procedure does *not* clean up all rows
> created by statspack. You need to clean them manually.
> At least until 9.2.0.6. A common trap that can cause a lot
> of teeth-grinding. DAMHIKT...
>

IIRC sppurge.sql has a part of sql commented out which does the cleanup you talk about.
Uncommenting that sql should clean things up fairly nicely .. at least that has been my experience...

Anurag Received on Thu Sep 08 2005 - 18:20:26 CDT