dblog

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;