通过sql查询后台alert日志

set pagesize 6000
set tab off
set linesize 180
col message_text format a140
col inst_id format 9999
col alert_time format a20

select inst_id,to_char(originating_timestamp,'yyyy-mm-hh hh24:mi:ss')as alert_time, message_text
from 
TABLE(gv$(cursor(select inst_id, originating_timestamp, message_text
                from v$diag_alert_ext
                where originating_timestamp > (sysdate - 1/24/60)
                      and inst_id=1
                --and (message_text like '%ORA-%' 
                --    or message_text ='Checkpoint not complete' 
                --    or upper(message_text) like 'ALTER%'
                --    )
              )
        )
)
order by inst_id, originating_timestamp;