Find oracle alertlog Errors With SQL Query
select message_text from X$DBGALERTEXT where rownum <= 50;
SELECT inst_id, originating_timestamp, MESSAGE_TEXT
FROM TABLE (
gv$ (
CURSOR (
SELECT inst_id, originating_timestamp, MESSAGE_TEXT
FROM v$diag_alert_ext
WHERE originating_timestamp > (SYSDATE – 4)
AND MESSAGE_TEXT LIKE ‘%ORA-%’)))
ORDER BY inst_id, originating_timestamp;
