Reclaim space in PERFSTAT tablespace
M.M.RJul 10 2009 — edited Jul 10 2009Hi All,
I created the perfstat TS with 300m,now the freespace is 58mb only.
I ahve purged the snap ID's but am unable to recollect the space into PERFASTAT ts
Please help me.
SQL> select tablespace_name,sum(bytes/(1024*1024)) MB from dba_free_space where tablespace_name='PERFSTAT'group by tablespace_name;
TABLESPACE_NAME MB
------------------------------ ----------
PERFSTAT 58.125
SQL> select tablespace_name,sum(bytes/(1024*1024)) MB from dba_DATA_FILES where tablespace_name='PERFSTAT'group by tablespace_name;
TABLESPACE_NAME MB
------------------------------ ----------
PERFSTAT 300
SQL>
SQL> select name,snap_id,to_char(snap_time,'DD.MM.YYYY:HH24:MI:SS')
"Date/Time" from stats$snapshot,v$database; 2
NAME SNAP_ID Date/Time
--------- ---------- -------------------
WOPROD 193 10.07.2009:08:00:05
WOPROD 181 09.07.2009:20:00:01
WOPROD 182 09.07.2009:21:00:04
WOPROD 183 09.07.2009:22:00:02
WOPROD 184 09.07.2009:23:00:01
WOPROD 185 10.07.2009:00:00:03
WOPROD 186 10.07.2009:01:00:03
WOPROD 187 10.07.2009:02:00:03
WOPROD 188 10.07.2009:03:00:02
WOPROD 189 10.07.2009:04:00:04
WOPROD 190 10.07.2009:05:00:02
NAME SNAP_ID Date/Time
--------- ---------- -------------------
WOPROD 191 10.07.2009:06:00:04
WOPROD 192 10.07.2009:07:00:02
13 rows selected.