Oracle Distributed Processing Interview Questions and Answers

 

Describe two phases of Oracle Two-phase commit?

Prepare phase - The global coordinator (initiating node) ask a participants to prepare
(to promise to commit or rollback the transaction, even if there is a failure) Commit
- Phase - If all participants respond to the coordinator that they are prepared,
the coordinator asks all nodes to commit the transaction, if all participants cannot
prepare, the coordinator asks all nodes to roll back the transaction.

Posted by:Richards