0x01--表空间使用率现状
通过查询可得知目前表空间使用情况如下图：可看到SYSAUX表空间和SYSTEM表空间使用率都已经高达99%，SYSAUX表空间甚至只剩下6.19MB的空间空间。
可看出两张系统关键表空间的使用率已经不容乐观。急需找出占用空间的幕后凶手！并将之绳之以法
0x02--AWRINFO脚本初步诊断
通过Oracle数据库自带的awrinfo脚本进行初步诊断，下边截取关键内容，可得到如下信息，快照过期信息是占用SYSAUX的元凶
0x03--v$sysaux_occupants视图查询明细
进一步查询SYSAUX表空间使用详细情况：
1 SQL> select owner,segment_name,partition_name,bytes/1024/1024 from dba_segments where tablespace_name='SYSAUX' order by 4 desc where rownum <=20; 2 3 OWNER SEGMENT_NAME PARTITION_NAME BYTES/1024/1024 4 ------------------------------ --------------------------------------------------------------------------------- ------------------------------ --------------- 5 SYS WRH$_ACTIVE_SESSION_HISTORY WRH$_ACTIVE_1404287032_0 7907 6 SYS WRH$_EVENT_HISTOGRAM_PK WRH$_EVENT__1404287032_0 3627 7 SYS WRH$_EVENT_HISTOGRAM WRH$_EVENT__1404287032_0 2560 8 SYS WRH$_LATCH WRH$_LATCH_1404287032_0 1600 9 SYS WRH$_SYSSTAT_PK WRH$_SYSSTA_1404287032_0 1472 10 SYS WRH$_LATCH_MISSES_SUMMARY_PK WRH$_LATCH__1404287032_0 1408 11 SYS WRH$_SQLSTAT WRH$_SQLSTA_1404287032_0 1344 12 SYS WRH$_LATCH_PK WRH$_LATCH_1404287032_0 1216 13 SYS WRH$_LATCH_MISSES_SUMMARY WRH$_LATCH__1404287032_0 1152 14 SYS WRH$_SYSSTAT WRH$_SYSSTA_1404287032_0 1088 15 SYS WRH$_ACTIVE_SESSION_HISTORY_PK WRH$_ACTIVE_1404287032_0 935 16 SYS WRH$_PARAMETER_PK WRH$_PARAME_1404287032_0 896 17 SYS WRH$_PARAMETER WRH$_PARAME_1404287032_0 759 18 SYS WRH$_SEG_STAT WRH$_SEG_ST_1404287032_0 712 19 SYS WRH$_SYSTEM_EVENT WRH$_SYSTEM_1404287032_0 688 20 SYS WRH$_SYSTEM_EVENT_PK WRH$_SYSTEM_1404287032_0 504 21 SYS WRH$_SERVICE_STAT_PK WRH$_SERVIC_1404287032_0 408 22 SYS WRH$_SQLSTAT_PK WRH$_SQLSTA_1404287032_0 352 23 SYS WRH$_DLM_MISC WRH$_DLM_MI_1404287032_0 320 24 SYS WRH$_DLM_MISC_PK WRH$_DLM_MI_1404287032_0 280 25 SYS WRH$_SEG_STAT_PK WRH$_SEG_ST_1404287032_0 256