ORA错误告警查询（通过SQL查询alert日志）

–查看2分钟内的一条ORA错误告警
select ora_err_msg from (select to_char(ORIGINATING_TIMESTAMP,‘yyyy-mm-dd hh24:mi:ss’) ||’ / ‘||MESSAGE_TYPE||’ / ‘||MESSAGE_LEVEL||’ / '||MESSAGE_TEXT as ora_err_msg from v$diag_alert_ext where to_char(ORIGINATING_TIMESTAMP ,‘yyyy-mm-dd hh24:mi:ss’) >to_char(sysdate - 2/ 60 / 24,‘yyyy-mm-dd hh24:mi:ss’) and MESSAGE_TEXT like ‘%ORA-%’ order by ORIGINATING_TIMESTAMP desc) where rownum=1;

–统计2分钟内ORA错误告警数目
select count(*) as ora_err_count from v$diag_alert_ext where MESSAGE_TEXT like ‘%ORA-%’ and to_char(ORIGINATING_TIMESTAMP ,‘yyyy-mm-dd hh24:mi:ss’) >to_char(sysdate - 2/ 60 / 24,‘yyyy-mm-dd hh24:mi:ss’) ;