Which of the following describes how a distributed resumable transaction behaves?

Which of the following describes how a distributed resumable transaction behaves?

Which of the following describes how a distributed resumable transaction behaves?

A.
The resumable setting on the initiating session determines the resumable conditions for
the entire distributed transaction.

B.
The resumable setting for the initiating instance determines the resumable conditions for
the entire distributed transaction.

C.
The resumable setting on the initiating session controls only that part of the transaction
that occurs within the local instance; remote resumable settings determine the behavior of
the distributed parts of the transaction.

D.
None of the above.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Jake from SF

Jake from SF

C is correct:

https://docs.oracle.com/cd/B28359_01/server.111/b28310/schema002.htm

Resumable Space Allocation and Distributed Operations
In a distributed environment, if a user enables or disables resumable space allocation, or if you, as a DBA, alter the RESUMABLE_TIMEOUT initialization parameter, only the local instance is affected. In a distributed transaction, sessions or remote instances are suspended only if RESUMABLE has been enabled in the remote instance.