Oracle OCP 1Z0 053 Q519(DBMS_RESUMABLE.SET_SESSION_TIMEOUT)

519.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 time-out 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.
Answer: B

兩個過程：

dbms_resumable.set_session_timeout(sessionID => , timeout => )
dbms_resumable.set_timeout(timeout => )

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074950/，如需轉載，請註明出處，否則將追究法律責任。