使用下面的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');