Re: problem: unique constraint error reported in alert log and load spike in unix box

Zhu Chao wrote:
> hi, all,
> We are running 9.2.0.5 on solaris 8, and we have some major problem
> with unique constraint error.
> Generally when unique constraint hit, application will get an
> ORA-00001 and that's it. But in our case recently we see some weird
> behavior from oracle.
> When we hit the unique constraint error and it got loged into alert
> log, and the load on unix box spikes. Application has been running for
> 1+ year and recently we upgraded database from 8174 to 9205.
>
>

Have you:

Checked for bugs at MetaLink?

Built test cases on both 8174 and 9205 to try and duplicate the problem?

Determined why your app keeps trying to duplicate a primary key? Received on Mon Oct 10 2005 - 10:05:48 CDT