对于 Oracle 12C 以下版本获取Oracle Alert Log的查询语句是：

SELECT decode(MESSAGE_LEVEL,1,'CRITICAL',2,'SEVERE',8,'IMPORTANT',16,'NORMAL',MESSAGE_LEVEL) as MESSAGE_LEVEL,RECORD_ID,ORIGINATING_TIMESTAMP,HOST_ADDRESS,MESSAGE_TEXT FROM v$appman_alertlog_ext WHERE TRIM (component_id) = 'rdbms' AND MESSAGE_TEXT LIKE '%ORA-%'

对于 12C 及以上版本：

SELECT decode(MESSAGE_LEVEL,1,'CRITICAL',2,'SEVERE',8,'IMPORTANT',16,'NORMAL',MESSAGE_LEVEL) as MESSAGE_LEVEL,RECORD_ID,ORIGINATING_TIMESTAMP,HOST_ADDRESS,MESSAGE_TEXT FROM appman_alertlog_view WHERE TRIM (component_id) = 'rdbms' AND MESSAGE_TEXT LIKE '%ORA-%'