Re: most frequent error messages in Oracle

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:41764c52$0$4310$afc38c87_at_news.optusnet.com.au...
> tomboy78 wrote:
>
> > Hi
> >
> > I'm a student and for a project I need to know what are the most
> > frequent error messages. Is there anyone who knows any surveys done or
> > is it possible to get this information from the data dictionary of
> > some live databases. I want to prove that the same error messages
> > reappear over and over.
> >
> > I'd like to fill in someting similar to the following sentence:
> > It is a fact that X% of all error messages count for X% of problems
> > produced.
> >
> > Thanks in advance
>
> I don't think you'd get any official or semi-official surveys from
anywhere,
> just anecdotes. Anecdotally, I'd expect the most common error to be 03113
> (End of file on communication channel).
>
> After that, 12514 and 12541 are likely to be in the top ten.
>
> I don't think 600 counts, because it covers so many things!
>
> 1555 doesn't count since 9i, either, thankfully.
>
> :-)

Yeah, I really miss that "good old" ORA-1555 error ;-) Received on Wed Oct 20 2004 - 14:34:43 CDT