title: What is the impact of COMMIT_POINT_STRENGTH parameter in Oracle DB?
body: <p>As per Oracle documentation, COMMIT_POINT_STRENGTH is the parameter which determines the impact of the commit of a Distributed Transaction? I have 2 database nodes in my application and COMMIT_POINT_STRENGTH is set to 1 in both nodes. If I initiate a transaction from one node for a table that exist in both nodes (by Synonyms). What happens to the transaction if the other node fails to commit data?</p>