Oracle 11g이상 alert log DB에서 확인하기

 

Oracle 11g이상 alert log DB에서 확인하기

SELECT record_id,originating_timestamp, message_text
FROM X$DBGALERTEXT
WHERE 1=1
--and RECORD_ID > 165500
and originating_timestamp > systimestamp-200
AND regexp_like(message_text, '(ORA-|error|WARNING)')
order by RECORD_ID desc;