Two Phase COmmit
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Two Phase COmmit

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Talking

    What is a two phase commit?
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    16

    two phase commit

    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.

  4. #4
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Thumbs up

    Thanx a lot, Guys.
    There Nothing You cannot Do, The problem is HOW.

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Very Interesting Explanation

    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
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width