Ask the Expert

What exactly is a multi-phase commit?

What exactly is a multi-phase commit? We have a requirement that we use a RDBMS that supports multi-phase commits. Can ORACLE 8i do that?

    Requires Free Membership to View

A multi-phase commit is not simply a database concept. In any case where more than one server connection -- literally a socket connection -- and more than one commit step bounds the transaction scope a multi-phase commit occurs. The challenge is implement rollback mechanics when any part of the chain fails. Transaction Process Monitors (TPM's) are used to monitor transaction steps and indicate status at the buisness process, i.e., the multi-phase level. However, backing out a failed transaction generally means writing logic for compensating transactions, which are used to back out individual transaction steps in a multi-phase rollback. I do not believe that Oracle has any multi-phase capability, because this is not an aspect of either the SQL language or its low level OCI library. However, I would check with Oracle tech support for a definitive answer.

This was first published in March 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: