Thursday 19 June 2014

View alert log from sql

In 11g, there is an easy way to read you database's alert log, using table X$DBGALERTEXT:



SELECT ORIGINATING_TIMESTAMP,
         MODULE_ID,
         PROCESS_ID,
         MESSAGE_TEXT
    FROM X$DBGALERTEXT
ORDER BY ORIGINATING_TIMESTAMP DESC;

No comments:

Post a Comment