Re: Full Tablespace (Statspack)

Scott Reynolds wrote:
> 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?
>
>
>
> Thanks in advance.
>
>
>

If you ran sppurge.sql, then there should be space in the tables to hold new snapshot data. And this script should be run regularly...which is why AWR does this automatically for you in 10g. So do you still get the ORA-1653 error after you have run sppurge script?

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com