Querying Oracle alert.log Errors With SQL Query

dbtut

6 years ago

You can query errors in Alert.log by sql query. You can use the following queries for this.

The following query returns with 20 rows.

SQL> select message_text from X$DBGALERTEXT where rownum <= 20;

1	SQL> select message_text from X$DBGALERTEXT where rownum <= 20;

SQL>  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 - 2)
AND MESSAGE_TEXT LIKE '%ORA-%')))
ORDER BY inst_id, originating_timestamp;

SQL> 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 - 2)

AND MESSAGE_TEXT LIKE '%ORA-%')))

ORDER BY inst_id, originating_timestamp;