RECO can use an existing connection or establish a new connection to other nodes - Oracle Transaction

Q.  RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction. When a connection is established, RECO automatically resolves all in-doubt transactions.
- Published on 19 Oct 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 23 Sep 15
    - The RECO background process of an Oracle Database instance automatically resolves failures involving distributed transactions.

    - At exponentially growing time intervals, the RECO background process of a node attempts to recover the local portion of an in-doubt distributed transaction.

    - RECO can use an existing connection or establish a new connection to other nodes involved in the failed transaction.

    - When a connection is established, RECO automatically resolves all in-doubt transactions.

    - Rows corresponding to any resolved in-doubt transactions are automatically removed from the pending transaction table of each database.

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.)