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