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@xxxxxxxxxxxxxxx>
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.
