Can anybody explain the purpose and uses of 2 Phase Commit in Oracle? Thank you.
asked
What is a 2 Phase Commit ?
Two phase commit is the protocol that allows for a transaction to be managed across a distributed network of servers.
There's a very good Wiki article on it:
Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote Procedural calls that reference a remote object. There are basically 2 phases in a 2 phase commit.
- Prepare Phase :: Global coordinator asks participants to prepare
- Commit Phase :: Commit all participants to coordinator to Prepared, Read only or abort Reply
