simple sppurge.sql and tablespace management issue
Dan AJun 11 2008 — edited Jun 12 2008Hi.
THe tablespace PERF that holds the statspack data is at 91% of its 92M size.
After I run the sppurge.sql script which truncates all the tables used for statspack reports, I see no difference in the size or the percentage used in the tablespace. Is it right to say that the size will not shrink?
That though the tables are now truncated, the size is still the same (though its not being used) ?
Thanks!