top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is a 2 Phase Commit in Oracle?

+1 vote
195 views
What is a 2 Phase Commit in Oracle?
posted Oct 15, 2014 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Two Phase commit is used in distributed data base systems. This is useful to maintain the integrity of the database so that all the users see the same values. It contains DML statements or Remote Procedural calls that reference a remote object.

 There are basically 2 phases in a 2 phase commit.
    a) Prepare Phase:  Global coordinator asks participants to prepare
    b) Commit Phase: Commit all participants to coordinator to Prepared, Read only or abort Reply
answer Oct 16, 2014 by Arun Gowda
Similar Questions
0 votes

Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.

...