Debug Methods Oracle (Coarse Grained Auditing)
Scenario There are many times, where there was an issue in production and you did not have any idea how it happened. The following article will give you some direction. Please note there are many other ways too. Currently, I will just focus on a method I had used during a similar situation. This error information is from the latest logs from Production said: ORA-00001: unique constraint (TABLE_ABCD.SYS_C006189415) violated Now the constraints to troubleshoot the above scenario are: You have limited access/privilege in production environment. The above was due to a duplicate record that came in and your process tried to insert that duplicate data. But what was that data that caused disruption? The answer could have been found out by using FlashBack Query feature from Oracle. This however is version specific. Let’s look into some other aspects of debugging. Observation There is no clue to the data that was being insert...