Re: looking at alert log

I have a perl monitoring script that you can use.

https://github.com/bgblanch/Monitor

William

On 11/18/2016 10:40 AM, Zelli, Brian 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