Statement is suspended results in automatically suspending transaction - Oracle Transaction

Q.  When a statement is suspended, it results in automatically suspending the transaction.
- Published on 12 Aug 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 22 Sep 15
    - Suspending a statement automatically results in suspending the transaction.

    - Thus all transactional resources are held during a statement suspend and resume.

    - When the error condition disappears, the suspended statement automatically resumes execution.

    - A resumable space allocation can be suspended and resumed multiple times during execution.

    - A suspension timeout interval is associated with resumable space allocations.

    - A resumable space allocation that is suspended for the timeout interval (the default is two hours) wakes up and returns an exception to the user.

    - A suspended statement may be forced to throw an exception using the DMBS_RESUMABLE.ABORT() procedure.

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