IF COMMITED?

Mar 27 posted in Oracle (RSS), 61 views.

Demand should be for sale to customers at the scene (music base) to help analyze why the operation clearly update our records are submitted, but every day dozens of W there are dozens of records shown by records such as not submitted.
March 24, 2009 customers go live, because not related to the development of engineers at the scene, click on the checked the database, the database found nothing abnormal, it is idle, waiting for almost nothing (EQ, LATCH, dblink, SEQUENCE, etc.). Initial suspected is not normal because of the author, the Panel resulted in a rollback, so that the procedures put into the original function is called automatically submitted to the show to submit;
March 25, 2009 Application of the response function to call before the problem still exists;
March 26, 2009 again archive log on to the scene to do logmnr, through the analysis, we found that right before the suspect is not in fact submitted to the SQL are submitted, and the question submitted in right, there is a relevant field home air operation, the problem is even more clear, what was originally a business Want to grab caused, but this procedure did not provide a VPN over the authority, and the SQL to them, allowing them to look for a! ! !
The beginning is not very willing to do logmnr analysis, it is estimated that the problem is the procedure done after logmnr directly exposed on the problem, and I write from the basis of the report to have more of, huh, huh.
Through this incident again shows that There's a reason! ! !

Originally posted want to find the problem of operational records, to find problems when they give before the deleted record, logmnr method of operation is very simple, there is the relevant article prior to the steps!