Re: looking at alert log

From: Rodrigo Mufalani <rodrigo_at_mufalani.com.br>
Date: Fri, 18 Nov 2016 16:55:20 +0000
Message-ID: <004AD93F-492B-4BE1-B67A-467ACEEDF9FC_at_mufalani.com.br>

Hello Brian,

  Usually I run this script or modify it a little bit depending what I am searching for:

set lin 1000
col data form a20
col process_id form a12
col module_id form a40
col message_text form a200

select
  to_char(originating_timestamp,'dd/mm/rr hh24:mi:ss') dt_hour

  , process_id
  , module_id
  , message_text

from
  sys.x$dbgalertext
where
  originating_timestamp >trunc(sysdate) order by
  originating_timestamp ;

Atenciosamente,

<http://www.mufalani.com.br/>Rodrigo Mufalani - Diretor Técnico | rodrigo_at_mufalani.com.br<mailto:rodrigo_at_mufalani.com.br> | +55 21 988 994 817
Mufalani - +55 21 3193 0326 | Rua Alm Grenfall, 405, Bl 3, Sl 310, Centro Empresarial Washington Luiz, Duque de Caxias, RJ | CEP 25085-009 | www.mufalani.com.br<mailto:rodrigo_at_mufalani.com.br>
<http://www.mufalani.com.br/>[cid:image001.png_at_01D241AB.C753D9E0]<http://www.mufalani.com.br/>[cid:image002.png_at_01D241AB.C753D9E0]

De: <oracle-l-bounce_at_freelists.org> em nome de "Zelli, Brian" <Brian.Zelli_at_RoswellPark.org> Responder para: "Brian.Zelli_at_RoswellPark.org" <Brian.Zelli_at_RoswellPark.org> Data: sexta-feira, 18 de novembro de 2016 14:40 Para: "oracle-l (oracle-l_at_freelists.org)" <oracle-l_at_freelists.org> Assunto: looking at alert log

Ok, I am running this script to check the alert log for errors and it runs every few minutes. How can I just look at the last few minutes as opposed to the entire day? So if I wanted to see it from 5 minutes ago till now? And repeat? Can’t quite figure out how to google the right question so sorry for asking.

select message_text from V$ALERT_LOG where to_char(originating_timestamp,'DD-Mon-YY') = to_char(SYSDATE, 'DD-Mon-YY') AND message_text LIKE '%ORA%';

Or does anybody have a better way of looking at the alert log thru sql that can pull out when it encounters an error?

Brian

This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.

--
http://www.freelists.org/webpage/oracle-l





image/png attachment: image001.png



image/png attachment: image002.png

Received on Fri Nov 18 2016 - 17:55:20 CET