Re: PERFSTAT tablespace and sppurge.sql
Date: Wed, 10 Dec 2008 04:44:33 -0800 (PST)
Message-ID: <920f7b91-66a6-4dd1-9260-d04f11145fd1@s9g2000prm.googlegroups.com>
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 DBAReceived on Wed Dec 10 2008 - 06:44:33 CST