Coping with multiple ORA-00001 errors
We have a java application written by an outside company which runs
on their own application server and connects to the database using JDBC. The database
is at 10.2.0.4 on RH Linux on Intel, is Dataguarded and runs in maximum availability mode.
Recently, they applied a patch to the application which had a bug in it and caused
it to bombard the database with masses of inserts of data which was already
in the database.
This caused a tenfold increase in the redo generated.
Oracle was unable to reject the duplicates fast enough for the application's
cache which meant that it started filling up and causing them grief. Enterprise Manager showed