Wait event SQL*Net break/reset to client caused by duplicate insert?

From: Peter Hitchman <pjhoraclel_at_gmail.com>
Date: Tue, 8 Apr 2008 20:54:35 +0100
Message-ID: <5e317f310804081254p1abfb828p180d43911509a8f1@mail.gmail.com>

Oracle 1.1.06 RAC on OEL 4 64 bit.

We are seeing an insert statement reporting "SQL*Net break/reset to client" as over 1/3 of its time.
On the face of it this event suggests network issues but nothing else backs this up as the cause.
So I looked at the Java code in question and a trace of one of the sessions.

What is happening is that an attempt is made to insert a row, most of the time a duplicate error results, the code catches this exception and does an update.
I was wondering if its the duplicate error and the exception handling which results in this wait event showing up.

All insights welcome



Received on Tue Apr 08 2008 - 14:54:35 CDT

Original text of this message