<<Previous Next>>
Oracle - What is Two-Phase
Commit? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
What is Two-Phase
Commit?
A distributed transaction can involve multiple servers. Two-Phase
commit protocol ensures that all database servers participating in
the transaction either commit all statements or roll back all
statements. This protocol is automatically triggered when COMMIT
command is written. There is no explicit coding or complex sql
statements that need to be written.
Oracle - What
is Two-Phase Commit? - April 10, 2009
at 11:00 AM by
What is Two-Phase Commit?
Two-Phase Commit has two phases, a prepare
phase and a commit phase.
It is the mechanism ensuring a
distributed transaction either commits on all involved nodes or
rolls back on all involved nodes.
Also read
The parser scans the statement and breaks it into logical units
such as keywords, identifiers and operators, A query or a sequence
tree is built using the units above. This is done to transform the
source data into the format required by the result set.............
READ COMMITTED: If row locks are obtained by a certain
transaction, then any other transaction that contains DML needs to
wait until the row locks have been released by that particular
transaction.............
Rollback segments undo changes when a transaction is rolled back,
they also ensure that transactions leave the uncommitted changes
unnoticed..............
Rollback Segment in oracle is used to store "undo" information
temporarily.........
Data Segment, Index Segment, Rollback Segment, and Temporary
Segment............
|
