Database Memory & 4030/4031 (MOSC)

MOSC Banner

Missing data in Oracle database when there is bulk insertion in the table

Oracle version: Oracle 11g Standard edition

Our application inserts approximately 1 million events per day in to the table.

During these processes, we are seeing missing data that we can find using gaps in sequence number column (called INDEX).

Whenever there is gap in INDEX column, there is also missing data in table.

Now, we need to find whether this data failed to insert into oracle table or deleted from oracle.

In Our application log files, we are not seeing any specific errors. Below is the random error which we observed in our log files.

“Oracle Error (100)”

Do you suggest any way or oracle log files to check for this use case?

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