Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alert Log Search Strings

Re: Alert Log Search Strings

From: mkeene <matthew_keeneNOmaSPAM_at_ansett.com.au.invalid>
Date: Tue, 11 Jan 2000 20:06:42 -0800
Message-ID: <18dae34d.3ff00968@usw-ex0101-003.remarq.com>


We have a script which goes through the alert logs for multiple instances and aggregates all the errors into a single report. We look for any occurrance of ORA- or OER- but ignore ORA-1109, ORA-279, ORA-308, ORA-283. We also report the high water mark, number of log switches and average/min/max time between them and the number of shutdowns/startups. Hope this gives you some ideas.

Received on Tue Jan 11 2000 - 22:06:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US