Alert log

set lines 150 pagesize 3000
col HOST_ID format a11 word wrap
col MODULE_ID format a7 truncate
col PROCESS_ID format a5
col ORGANIZATION_ID format a5 truncate
col COMPONENT_ID format a5
col MESSAGE_GROUP format a11
col MESSAGE_TEXT format a50 word wrap
select * from
(
select TO_CHAR(ORIGINATING_TIMESTAMP, 'dd.mm.yyyy hh24:mi:ss') dt, ORGANIZATION_ID, COMPONENT_ID, MESSAGE_GROUP, MESSAGE_TEXT, HOST_ID, MODULE_ID, PROCESS_ID
from X$DBGALERTEXT
where MESSAGE_TEXT like '%ORA-%'
order by ORIGINATING_TIMESTAMP desc
) where rownum <= 15
order by dt;