oracle 257,ORACLE 10g SYSAUX表空间快速增长之WRH$_ACTIVE_SESSION_HISTORY篇

近一段时间监控生产数据库的表空间使用情况，发现SYSAUX表空间非常大(17g之多)，而且每天都有几十M的增长，看到此现象后，认为这很不正常，分析SYSAUX表空间那些segments占用空间比较大：

SELECT SUM(T.BYTES)/1024/1024 segments_SIZE,T.segment_name

FROM Dba_Segments t

WHERE t.tablespace_name='SYSAUX'

AND ROWNUM<21

GROUP BY T.segment_name ORDER BY 1 DESC;

segments_size

segment_name

10631.0625

WRH$_ACTIVE_SESSION_HISTORY

2683.0625

WRH$_ACTIVE_SESSION_HISTORY_PK

1026.0625

WRH$_LATCH_MISSES_SUMMARY_PK

730.0625

WRH$_LATCH_MISSES_SUMMARY

618.0625

WRH$_SQLSTAT

564.0625

WRH$_LATCH

496.9375

WRH$_LATCH_PK

490

I_WRI$_OPTSTAT_H_OBJ#_ICOL#_ST

471.8125

WRH$_SYSSTAT_PK

395

SYS_LOB0000009001C00038$$

378

WRI$_OPTSTAT_HISTGRM_HISTORY

3