Statement running in resumable mode - Oracle Transaction

Discussion

• Nirja Shah   -Posted on 22 Sep 15
  - Oracle provides a means for suspending, and later resuming, the execution of large database operations in the event of space allocation failures.
  
  - This enables an administrator to take corrective action, instead of the Oracle database server returning an error to the user.
  
  - After the error condition is corrected, the suspended operation automatically resumes.
  
  - A statement runs in a resumable mode only when the client explicitly enables resumable semantics for the session using the ALTER SESSION statement.
  
  - Resumable space allocation is suspended when one of the following conditions occur:
  1. Out of space condition
  2. Maximum extents reached condition
  3. Space quota exceeded condition
  
  - For nonresumable space allocation, these conditions result in errors and the statement is rolled back.
  
  - Suspending a statement automatically results in suspending the transaction.
  
  - Thus all transactional resources are held through a statement suspend and resume.
  
  - When the error condition disappears (for example, as a result of user intervention or perhaps sort space released by other queries), the suspended statement automatically resumes execution.

➨ Post your comment / Share knowledge