oracle – select alertlog

Einfache Abfrage:

select  *
  from  sys.x$dbgalertext

Fehler Gruppiert pro Tag

select  m oraerr,count(*) cnt,
        sum(decode(d,s   ,1,null))Today,
        sum(decode(d,s-01,1,null))"T-01",
        sum(decode(d,s-02,1,null))"T-02",
        sum(decode(d,s-03,1,null))"T-03",
        sum(decode(d,s-04,1,null))"T-04",
        sum(decode(d,s-05,1,null))"T-05",
        sum(decode(d,s-06,1,null))"T-06",
        sum(decode(d,s-07,1,null))"T-07",
        sum(decode(d,s-08,1,null))"T-08",
        sum(decode(d,s-09,1,null))"T-09"
  from (select  message_text                 m,
                trunc(originating_timestamp) d,
                trunc(sysdate)               s
          from  sys.x$dbgalertext 
          where originating_timestamp > sysdate-7
          and   message_text like '%ORA-%')
  group by m
  order by 1 desc;