ocp-119

来源:互联网 发布:街舞网络调查 编辑:程序博客网 时间:2024/04/27 18:05

QUESTION NO: 119
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


您会注意到由于空间限制
一个长期运行的交易被暂停,也没有暂停后解决问题的触发事件。你也注意到关键的事务恰好即将达到可恢
复超时值。这些行动的哪一个是适当的?

B. 当你解决这个问题时, 使用DBMS可恢复的.设置会话超时程序以延长会
话的超时时间。


0 0
原创粉丝点击