Re: most frequent error messages in Oracle

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 20 Oct 2004 21:30:32 +1000
Message-Id: <41764c52$0$4310$afc38c87@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.

:-)

Regards
HJR Received on Wed Oct 20 2004 - 06:30:32 CDT