Monthly Archives: April 2015

Reading Alert Log Using V$DIAG_ALERT_EXT (sqlplus 11g+)

Got a small snippet to read alert log from sqlplus in 11g without doing any setup. This is quite useful when you are firefighting. Previously this was available through X$ view.

select TO_CHAR(A.ORIGINATING_TIMESTAMP, 'dd.mm.yyyy hh24:mi:ss') MESSAGE_TIME
,message_text
,host_id
,inst_id
,adr_home 
from V$DIAG_ALERT_EXT A
where A.ORIGINATING_TIMESTAMP > sysdate-1
and component_id='rdbms'
and message_text like '%ORA-%'
order by 1 desc;
Advertisements