You notice that a long-running transaction is suspended due to a space constraint, and there
is no AFTER SUSPEND triggered event addressing the issue. You also note that the critical
transaction is just about to reach the RESUMABLE_TIMEOUT value.
Which of these actions is appropriate?
A.
Abort the session, fix the space problem, then resubmit the transaction.
B.
Use the DBMS_RESUMABLE.SET_SESSION_TIMEOUT procedure to extend the timeout for the session while you fix the problem.
C.
Do nothing, let the transaction fail, then fix the problem.
D.
Use Segment Shrink to clean up the table.
E.
Use the DBMS_RESUMABLE.SET_TIMEOUT procedure to extend the time-out for the
session while you fix the problem.
B is correct:
https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_resuma.htm
SET_SESSION_TIMEOUT Procedure
This procedure sets the timeout of resumable space allocations for a session with session_id. The new timeout setting applies to the session immediately. If session_id does not exist, no operation occurs.
Syntax
DBMS_RESUMABLE.SET_SESSION_TIMEOUT (
session_id IN NUMBER,
timeout IN NUMBER);
SET_TIMEOUT Procedure
This procedure sets the timeout of resumable space allocations for the current session. The new timeout setting applies to the session immediately.
Syntax
DBMS_RESUMABLE.SET_TIMEOUT (
timeout IN NUMBER);
Note that you cannot select the session ID in SET_TIMEOUT.