oracle告警sysaux表空间满告警

使用下面的sql查看信息

select * from dba_data_files where tablespace_name='SYSAUX';

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;
select * from dba_segments where segment_name='WRH$_EVENT_HISTOGRAM_PK';
select a.snap_interval,a.retention,a.topnsql from dba_hist_wr_control a;
select * from dba_hist_wr_control;
  select * from WRH$_ACTIVE_SESSION_HISTORY;
  SELECT COUNT(*) FROM dba_hist_snapshot;

  SELECT * FROM WRM$_SNAPSHOT t ORDER BY t.snap_id ASC;


  select * from all_part_tables where table_name='WRH$_ACTIVE_SESSION_HISTORY';
  select * from all_tab_partitions where table_name='WRH$_EVENT_HISTOGRAM_PK';
show_space的使用方式，查看分区表的信息
exec show_space('WRH$_ACTIVE_SESSION_HISTORY','SYS','TABLE PARTITION','WRH$_ACTIVE_SES_MXDB_MXSN');