You want the execution of a large database operation to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600

Question

Options

• ABefore a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE
• BData Manipulation Language (DML) operations are resumable, provided that they are not
• CA suspended statement will report an error if no corrective action has taken place during timeout
• DSuspending a statement automatically results in suspending a transaction and releasing all the
• EA resumable statement can be suspended and resumed only once during execution.

• A
  71% (44)
• B
  8% (5)
• D
  5% (3)
• E
  16% (10)

Explanation

A statement executes in resumable mode only if its session has been enabled for resumable space allocation by one of the following actions: The ALTER SESSION ENABLE RESUMABLE statement is issued in the session before the statement executes when the RESUMABLE_TIMEOUT initialization parameter is set to a The ALTER SESSION ENABLE RESUMABLE TIMEOUT timeout_value statement is issued in the session before the statement executes, and the timeout_value is a nonzero value. https://docs.oracle.com/cd/E57425_01/121/ADMIN/schema.htm#i1007794

No community discussion yet for this question.