Re: looking at alert log

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Mon, 21 Nov 2016 09:55:41 +1100
Message-ID: <CAFeFPA854nWsz-MEUDaOKaZ8t0DPNVZjNstb4b63fqHb3gC-mA_at_mail.gmail.com>

Several options have been given already...Here is another You can keep track of the rownumber in a separate file and read this file next time you run the check to find the row number from which to start. If the alert log has been cycled the number of rows is generally smaller than the number in the file and you start from beginning.

When cycling the alert log run a check on the last bit of the alert log or you will miss it's content in the monitoring

Jack van Zanen

---

This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation

On Sat, Nov 19, 2016 at 3:40 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:

> 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

Received on Sun Nov 20 2016 - 23:55:41 CET