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

Ahh, sorry, had 10g install I was playing with and gave a 10g answer to

a 9i questions..

Search for this in 9.2 sppurge, the following 2 statements are commented. This has the same effect as in 10g, though.

/* Delete any dangling SQLtext */
/*

    Rem The following statement deletes any dangling SQL statements which

    Rem are no longer referred to by ANY snapshots. This statment has

been

    Rem commented out as it can be very resource intensive.

You can try this to see if this may actually be the source of your growth:
select /*+ index_ffs(st) */ count(*)
 from perfstat.stats$sqltext st

         where (hash_value, text_subset) not in
         (select /*+ hash_aj full(ss) */ hash_value, text_subset
         from perfstat.stats$sql_summary ss );