RECO abbreviation - Oracle Transaction - Recover

Discussion

• Nirja Shah   -Posted on 23 Sep 15
  - The recover process (RECO) is a background process used with the distributed database configuration that automatically resolves failures involving distributed transactions.
  
  - The RECO process of a node automatically connects to other databases involved in an in-doubt distributed transaction.
  
  - When the RECO process reestablishes a connection between involved database servers, it automatically resolves all in-doubt transactions, removing from each database's pending transaction table any rows that correspond to the resolved in-doubt transactions.
  
  - If the RECO process fails to connect with a remote server, RECO automatically tries to connect again after a timed interval.
  
  - However, RECO waits an increasing amount of time (growing exponentially) before it attempts another connection.
  
  - The RECO process is present only if the instance permits distributed transactions.
  
  - The number of concurrent distributed transactions is not limited.

➨ Post your comment / Share knowledge