Tuesday, January 28, 2014

Learn about commit_point_strength parameter

Are you running SQL statements between multiple databases that require commit points?  Have you run into "enq: TX - contention" waits for no good reason at all that is obvious after looking into the issue?  Read Nigel Noble's article about troubleshooting this type of scenario and suggests that commit_point_strength is the magic bullet to fix his issue…even though he gets another answer from Oracle which also might interest you too!

No comments:

Post a Comment