Re: Full Tablespace (Statspack)

From: astalavista <nobody_at_nowhere.com>
Date: Tue, 14 Aug 2007 21:21:11 +0200
Message-ID: <46c200a4$0$416$426a34cc@news.free.fr>

>I am currently running Oracle 9i and unfortunately my STATSPACK tablespace
> has filled 100%. When collecting statistics now, I get the following
> error
> in my alert log:
>
> ORA-1653: unable to extend table PERFSTAT.STATS$SQLTEXT by 16 in
> tablespace
> STATSPACK
>
>
> This makes sense as I limited the datafile size to 1500 MB. I have also
> run
> the sppurge.sql script to remove old snapshots with the idea that it would
> free up enough space to continue collecting statistics. Unfortunately.
>
> Any ideas or will I have to run the sptrunc.sql script to remove STATSPACK
> and reinstall after dropping/recreating the STATSPACK tablspace?

sptrunc delete all stats
but doesn't remove user/tablespace for STATSPACK...

HTH Received on Tue Aug 14 2007 - 14:21:11 CDT