Which two methods can be used to enable a session for resumable space allocation?

You want to execute the following statements in resumable mode:
CREATE TABLE … AS SELECT
CREATE INDEX
CREATE MATERIALIZED VIEW
Which two methods can be used to enable a session for resumable space allocation? (Choose two.)

You want to execute the following statements in resumable mode:
CREATE TABLE … AS SELECT
CREATE INDEX
CREATE MATERIALIZED VIEW

Which two methods can be used to enable a session for resumable space allocation? (Choose two.)

A.
Set the RESUMABLE_TIMEOUT initialization parameter to true.

B.
Set the RESUMABLE_TIMEOUT initialization parameter to none.

C.
Execute the ALTER SESSION ENABLE RESUMABLE statement.

D.
Execute the ALTER DATABASE ENABLE RESUMABLE statement.

E.
Set the RESUMABLE_TIMEOUT initialization parameter to a nonzero value.

Explanation:
The default for a new session is resumable mode disabled, unless the RESUMABLE_TIMEOUT initialization parameter is set to a nonzero value.You can enable resumable space allocation system wide and specify a timeout interval by setting the RESUMABLE_TIMEOUT initialization parameter. For example, the following setting of the RESUMABLE_TIMEOUT parameter in the initialization parameter file causes all sessions to initially be enabled for resumable space allocation and sets the timeout period to 1 hour:
RESUMABLE_TIMEOUT = 3600

If this parameter is set to 0, then resumable space allocation is disabled initially for all sessions. This is the default.
A user can enable resumable mode for a session, using the following SQL statement:
ALTER SESSION ENABLE RESUMABLE;
To disable resumable mode, a user issues the following statement:
ALTER SESSION DISABLE RESUMABLE;

REF: Oracle(r) 10g Administrator Guide, 14-11



Leave a Reply 1

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


mr_tienvu

mr_tienvu

Correct answer is