Finding when Rollbacks occur in Oracle
Posted on 2013-11-04
We have an application we suspect is not properly hadnling rollbacks. The symptom is occasionally (maybe 1 out of 1000 times) a scenario occurs one of the tables gets out of sync such that it appears a transaction is partially committed.
When this occurs our dba cannot find any errors in the Oracle log, but I am not sure we have logging levels at the highest setting.
When the problem occurs next, we can idenify the approximate time that it occured. Is there any Oracle tool that can show us if any rollbacks occurred at that time?