欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

oracle告警sysaux表空间满告警

程序员文章站 2022-07-01 09:41:17
...

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