What is a two phase commit?
Printable View
What is a two phase commit?
Hi,
See TWO PHASE COMMIT comes in Distributed Database System.In Two phase Commit all the database servers in distributed database either commit or rollback as a unit.
For e.g Say u are running a transaction which updates 3 databases.So incase if one database is not able to commit the transaction,the other databases will also not commit the transactions.So there is data integrity in distributed database system.Oracle automatically performs TWO PHASE COMMIT.
In case of any help needed please be free to ask me at [email protected]
Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
[email protected]
Hi,
The two phase commit mostly works in a distributed environment where it any of the transaction fails(due crash,powerfailure,etc) it is either comited or rolledback.
Thanx a lot, Guys.
Hi, 11th May 2001 20:27 hrs *******
Find enclosed a very good link on two phase commit explained digramatically.
http://www.sei.cmu.edu/str/descriptions/dtpc_body.html
Cheers
Padmam