tablespace syaux growing too much
Last day i saw SYSAUX tablespace was growing too much. It was due to some Active Session History objects (WRH$) were growing too much: set linesize 190 col OWNER for a20 col SEGMENT_NAME for a30 select OWNER, SEGMENT_NAME, SEGMENT_TYPE, sum(BYTES)/1024/1024 Mbytes from dba_segments where TABLESPACE_NAME like 'SYSAUX' and SEGMENT_TYPE like 'TABLE%' and BYTES>1024*1024*10 and SEGMENT_NAME like 'WRH%' group by OWNER, SEGMENT_NAME, SEGMENT_TYPE order by 4; OWNER SEGMENT_NAME SEGMENT_TYPE MBytes -------------------- ------------------------------ ------------------ ---------------- SYS WRH$_PARAMETER TABLE PARTITION 12 SYS WRH$_ACTIVE_SESSION_HISTORY TABLE PARTITION 13 SYS WRH$_SYSMETRIC_HISTORY TABLE 14 SYS WRH$_SYSSTAT TABLE PARTITION