54 You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT par

54
You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT
parameter set to a nonzero value.
Which three statements about resumable space allocation are true? (Choose three.)
A. Even with resumable space allocation enabled for your database, you can disable resumable space
allocation for a single session.
B. A resumable statement is suspended only if an out of space error occurs.
C. When a resumable statement is suspended, the transaction that contains the statement is also

suspended.

D. A resumable statement can only be suspended and resumed once during the execution of the
statement.
E. You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are
suspended for a session.

Correct Answer: ACE
Section: (none)
Explanation
Explanation/Reference:
Explanation:
The following three statements are true about resumable space allocation:
Even with resumable space allocation enabled for your database, you can disable resumable space
allocation for a single session.
When a resumable statement is suspended, the transaction that contains the statement is also suspended.
You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are
suspended for a session.

Resumable space allocation is an Oracle feature that allows certain statements to be suspended if space
errors, such as out of space errors, space quota exceeded errors, or maximum extents reached errors,
occur. Resumable statements include SELECT statements, DML statements, SQL*Loader imports and
exports, and some DDL statements.
You enable resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a value
greater than zero. The parameter represents the amount of time, in seconds, that a resumable statement
will be suspended before it is terminated and an error is generated. You can also set this value for a
session using the ALTER SESSION ENABLE RESUMABLE TIMEOUT n; statement, or, you can disable
resumable space allocation for a session using the ALTER SESSION DISABLE RESUMABLE; statement.
If you have enabled resumable space allocation and a resumable statement experiences a space error,
the statement is suspended. If the statement is contained within a transaction, the transaction is also
suspended. This gives you the opportunity to correct the space issue. After the space issue is corrected,
the suspended statement automatically resumes execution.

You can query the V $SESSION_WAIT dynamic performance view to identify the statements that are
suspended for a session. The event column of the V$SESSION_WAIT view will display statement
suspended, wait error to be cleared for a statement that is suspended. The sid column identifies the
session id that executed the suspended statement, and the seconds_in_wait column displays the number
of seconds the statement has been suspended. The option that states a resumable statement is
suspended only if an out of space error occurs is incorrect. A resumable statement is also suspended if a
space quota is exceeded or a maximum extents reached error occurs.
The option that states a resumable statement can only be suspended and resumed once during the
execution of the statement is incorrect. A statement can be suspended and resumed multiple times during
its execution.