Re: looking at alert log

From: Rodrigo Mufalani <rodrigo@xxxxxxxxxxxxxxx>
To: "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>, "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 18 Nov 2016 16:55:20 +0000

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@xxxxxxxxxxxxxxx<mailto:rodrigo@xxxxxxxxxxxxxxx> | +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@xxxxxxxxxxxxxxx>
<http://www.mufalani.com.br/>[cid:image001.png@01D241AB.C753D9E0]<http://www.mufalani.com.br/>[cid:image002.png@01D241AB.C753D9E0]

De: <oracle-l-bounce@xxxxxxxxxxxxx> em nome de "Zelli, Brian"
<Brian.Zelli@xxxxxxxxxxxxxxx>
Responder para: "Brian.Zelli@xxxxxxxxxxxxxxx" <Brian.Zelli@xxxxxxxxxxxxxxx>
Data: sexta-feira, 18 de novembro de 2016 14:40
Para: "oracle-l (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
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.

References:
- looking at alert log
  - From: Zelli, Brian

Re: looking at alert log

Other related posts: