DEVFYI - Developer Resource - FYI

What is a 2 Phase Commit

ORACLE Interview Questions and Answers (Part 4)

(Continued from previous question...)

619. What is a 2 Phase Commit

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.
a) Prepare Phase :: Global coordinator asks participants to prepare
b) Commit Phase :: Commit all participants to coordinator to Prepared, Read only or abort Reply

(Continued on next question...)

Other Interview Questions