Database Administration (MOSC)

MOSC Banner

Coping with multiple ORA-00001 errors

edited May 4, 2009 3:23PM in Database Administration (MOSC) 1 commentAnswered
Hi all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center