Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sppurge (Statspack Purge) does not seem to free up space

Re: sppurge (Statspack Purge) does not seem to free up space

From: Anurag Varma <avoracle_at_gmail.com>
Date: 11 Feb 2005 07:33:14 -0800
Message-ID: <1108135994.685033.156300@c13g2000cwb.googlegroups.com> 






Try increasing the pctused for all perfstat's tables (from 40 to 70 or
80).


Also, try pinpointing which table is not reusing the free space.



Even with 40 .. I'd expect the usage to stabilize at some point...



Anurag
Received on Fri Feb 11 2005 - 09:33:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US