Oracle Database Discussions

Hi,
I have found that TOOLS tablespace is 99%.
The tools tablespace is typically used for collecting database statistics – not part of the application. These include Quest and Perfstat. How can I check at the objects in the tools tablespace to see what has grown and then determine if we need to purge data and reorg the objects.
The mount point for this database is only 8 gig and is 84% used so we should not add “overhead” space unless absolutely necessary. The tools tablespace is already large for the size of the rest of the database.
/dev/orabwelv 8388608 7011424 1377184 84% /ORACLE/BWEBPRD


These are the contents in the tablespace
OWNER TABLE_NAME OBJECT_TYPE TABLESPACE_NAME
---------- ------------------------------ ------------------ ------------------------------
ORACLE PLAN_TABLE TABLE TOOLS
ORACLE_APP STPL_DBAPRVS_PENDINGL TABLE TOOLS
ORACLE_APP STPL_DBAPRVS_ACTIVITY_LOGL TABLE TOOLS
ORACLE T_WEBBPRD TABLE TOOLS
POSTD PLAN_TABLE TABLE TOOLS
MONITORER TABLESPACE_GROWTH TABLE TOOLS
MONITORER SEGMENT_GROWTH TABLE TOOLS

OWNER TABLE_NAME OBJECT_TYPE TABLESPACE_NAME
---------- ------------------------------ ------------------ ------------------------------
PERFSTAT STATS$PGA_TARGET_ADVICE TABLE TOOLS
PERFSTAT STATS$SQL_WORKAREA_HISTOGRAM TABLE TOOLS
PERFSTAT STATS$SHARED_POOL_ADVICE TABLE TOOLS
PERFSTAT STATS$STATSPACK_PARAMETER TABLE TOOLS
PERFSTAT STATS$INSTANCE_RECOVERY TABLE TOOLS
PERFSTAT STATS$PARAMETER TABLE TOOLS
PERFSTAT STATS$IDLE_EVENT TABLE TOOLS
PERFSTAT STATS$PGASTAT TABLE TOOLS
PERFSTAT STATS$SEG_STAT_OBJ TABLE TOOLS
PERFSTAT STATS$SEG_STAT TABLE TOOLS
PERFSTAT STATS$SQL_PLAN TABLE TOOLS

OWNER TABLE_NAME OBJECT_TYPE TABLESPACE_NAME
---------- ------------------------------ ------------------ ------------------------------
PERFSTAT STATS$SQL_PLAN_USAGE TABLE TOOLS
PERFSTAT STATS$UNDOSTAT TABLE TOOLS
PERFSTAT STATS$DLM_MISC TABLE TOOLS
PERFSTAT STATS$RESOURCE_LIMIT TABLE TOOLS
PERFSTAT STATS$SQL_STATISTICS TABLE TOOLS
PERFSTAT STATS$SQLTEXT TABLE TOOLS
PERFSTAT STATS$SQL_SUMMARY TABLE TOOLS
PERFSTAT STATS$ENQUEUE_STAT TABLE TOOLS
PERFSTAT STATS$WAITSTAT TABLE TOOLS
PERFSTAT STATS$BG_EVENT_SUMMARY TABLE TOOLS
PERFSTAT STATS$SESSION_EVENT TABLE TOOLS

OWNER TABLE_NAME OBJECT_TYPE TABLESPACE_NAME
---------- ------------------------------ ------------------ ------------------------------
PERFSTAT STATS$SYSTEM_EVENT TABLE TOOLS
PERFSTAT STATS$SESSTAT TABLE TOOLS
PERFSTAT STATS$SYSSTAT TABLE TOOLS
PERFSTAT STATS$SGASTAT TABLE TOOLS
PERFSTAT STATS$SGA TABLE TOOLS
PERFSTAT STATS$ROWCACHE_SUMMARY TABLE TOOLS
PERFSTAT STATS$ROLLSTAT TABLE TOOLS
PERFSTAT STATS$BUFFER_POOL_STATISTICS TABLE TOOLS
PERFSTAT STATS$LIBRARYCACHE TABLE TOOLS
PERFSTAT STATS$LATCH_MISSES_SUMMARY TABLE TOOLS
PERFSTAT STATS$LATCH_PARENT TABLE TOOLS

OWNER TABLE_NAME OBJECT_TYPE TABLESPACE_NAME
---------- ------------------------------ ------------------ ------------------------------
PERFSTAT STATS$LATCH_CHILDREN TABLE TOOLS
PERFSTAT STATS$LATCH TABLE TOOLS
PERFSTAT STATS$TEMPSTATXS TABLE TOOLS
PERFSTAT STATS$FILESTATXS TABLE TOOLS
PERFSTAT STATS$DB_CACHE_ADVICE TABLE TOOLS
PERFSTAT STATS$SNAPSHOT TABLE TOOLS
PERFSTAT STATS$LEVEL_DESCRIPTION TABLE TOOLS
PERFSTAT STATS$DATABASE_INSTANCE TABLE TOOLS

Please Suggest

Message was edited by:
user592074