PERFSTAT
Below sql will trigger perfstat purging,Trigger this in off business hours as this will generate lot of Redo logs and try to purge every 15 days@sppurge.sql
Use this SQL to get large objects of PERFSTAT.
select segment_name,bytes/1024/1024/1024,segment_type from dba_segments where owner='PERFSTAT' order by 2;
As delete operation is performned by sppurge.sql,Need to perform table movement to claim free space.
alter table PERFSTAT.STATS$SQL_SUMMARY move tablespace SYSAUX
alter table PERFSTAT.STATS$SQL_SUMMARY move tablespace PERFSTAT
select INDEX_NAME,status from dba_indexes where owner='PERFSTAT';
alter index PERFSTAT.STATS$SQL_SUMMARY_PK rebuild online;
NOTE:The above table name may vary but would be of similar kind.
