2 Phase Commit

{\rtf1\ansi\ansicpg1252\deff0\deflang16393{\fonttbl{\f0\froman\fprq2\fcharset0 Times New Roman;}{\f1\fnil\fcharset0 Calibri;}{\f2\fnil\fcharset2 Symbol;}}
{\*\generator Msftedit 5.41.21.2509;}\viewkind4\uc1\pard\li720\lang1033\b\f0\fs28 Two Phase Commit: \b0 Oracle provides the same assurance of data consistency in a distributed environment as in a non-distributed environment.\par
There is two phases:\par
\pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent360{\pntxtb\'B7}}\fi-360\li1080\tx1080\b Prepare Phase \endash \b0 initiating node called global co-ordinator notifies all sites involved in transaction to be ready to either commit or rollback the transaction.\par
\pard\sa200\sl276\slmult1\b\par
Commit Phase \endash\b0 If there is no problem in prepare phase, then all sites commit their transactions. If network or node failure occurs then all sites rollback their transactions.\lang9\f1\par
}