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