Re: PERFSTAT tablespace and sppurge.sql

On 10 Dec, 12:44, sybrandb <sybra..._at_gmail.com> wrote:
> On 10 dec, 12:31, trub3101 <trub3..._at_sky.com> wrote:
>
> > Hi all,
>
> > Yesterday I purged 80% of the my statspack snapshots using sppurge.sql
> > however, the PERFSTAT tablespace remains the same size as before the
> > purge.
>
> > My question is (and somehow I believe I should know the answer to
> > this!) how comes the PERFSTAT tablespace has not shrunk accordingly?
>
> > Thanks in advance,
>
> > tb3101
>
> Because tablespaces behave like humans ;)
> They gain weight easily, but they only loose it with hard work and
> exercise...
>
> Seriously: Oracle has never deallocated space automatically. This is
> obvious as both allocations and de-allocations are costly operations.
> Oracle doesn't have the 'jo-jo effect' observed in persons who try to
> slim down.
> You would need to resize the tablespace yourself. Preferably before
> Christmas ;)
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Many thanks Sybrand!

That pretty much explains it! Received on Wed Dec 10 2008 - 06:54:12 CST