Which two actions would enable resumable space allocation at the instance level?

You want to enable resumable space allocation at the instance level.
Which two actions would enable resumable space allocation at the instance level? (Choose
two.)

You want to enable resumable space allocation at the instance level.
Which two actions would enable resumable space allocation at the instance level? (Choose
two.)

A.
issuing the ALTER SYSTEM ENABLE RESUMABLE; statement

B.
issuing the ALTER SESSION ENABLE RESUMABLE; statement

C.
modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

D.
issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

Show Hint

Leave a Reply 2

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

zimba

zimba

Answer is B & C

How Resumable Space Allocation Works

The following is an overview of how resumable space allocation works. Details are contained in later sections.

A statement executes in a resumable mode only if its session has been enabled for resumable space allocation by one of the following actions:

The RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.
The ALTER SESSION ENABLE RESUMABLE statement is issued.

Reply

zimba

zimba

Apologies. The above is for session not instance as required by the question so answer is indeed C & D.

Reply