Two Phase COmmit

[sudip]

What is a two phase commit?

[rohitsn]

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 rohitsn@altavista.com


Regards,
Rohit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com

[harvy]

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.

[sudip]

Thanx a lot, Guys.

[padmam]

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