When does a statement runs in a resumable mode?

Options
- When the client implicitly enables resumable semantics for the session using the ALTER SESSION statement
- When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement
- When the client implicitly enables resumable semantics for the session using the CREATE SESSION statement
- When the client explicitly enables resumable semantics for the session using the CREATE SESSION statement

CORRECT ANSWER : When the client explicitly enables resumable semantics for the session using the ALTER SESSION statement

Discussion Board
Resumable mode

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.

Prajakta Pandit 02-17-2017 03:07 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲