OCP-1Z0-053-V12.02-519题

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

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/13431595

你注意到由于空间的限制，一个长久运行的事务被挂起，也没有AFTER SUSPEND触发器去解决这个问题。你也注意到关键事务快达到RESUMABLE_TIMEOUT 的值。

SET_SESSION_TIMEOUT(sessionID, timeout)

This procedure sets the timeout interval of resumable space allocation for the session with sessionID. The parameter timeout is in seconds. The new timeout setting will applies to the session immediately. If the session does not exist, no action is taken.

官方参考： http://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11598

使用DBMS_RESUMABLE.SET_SESSION_TIMEOUT程序包来延长超时的会话，来解决问题。