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