Failure of a distributed transaction reason - Oracle Transaction

Q.  What is the exact reason for which you can force the failure of a distributed transaction?
- Published on 12 Aug 15

a. To observe RECO automatically resolving the local portion of the transaction
b. To practice manually resolving in-doubt distributed transactions and observing the results
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - You can force the failure of a distributed transaction for the following reasons:

    1. To observe RECO automatically resolving the local portion of the transaction

    2. To practice manually resolving in-doubt distributed transactions and observing the results

    - RECO (Oracle RECOverer Process) is an Oracle background process created when you start an instance with DISTRIBUTED_TRANSACTIONS= in the initialization parameter file.

    - The RECO process will try to resolve in-doubt transactions across Oracle distributed databases.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)