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://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11598
您注意到由于空间约束，一个长时间运行的事务被挂起，并且没有AFTER SUSPEND触发器去解决这个问题时。你也注意到关键事务快达到RESUMABLE_TIMEOUT的值。
使用DBMS_RESUMABLE.SET_SESSION_TIMEOUT过程来延长超时的会话，来解决问题。
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://docs.oracle.com/cd/E11882_01/server.112/e25494/schema.htm#ADMIN11598
您注意到由于空间约束，一个长时间运行的事务被挂起，并且没有AFTER SUSPEND触发器去解决这个问题时。你也注意到关键事务快达到RESUMABLE_TIMEOUT的值。
使用DBMS_RESUMABLE.SET_SESSION_TIMEOUT过程来延长超时的会话，来解决问题。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2122187/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
1Z0-053 V13.02 Q518
下一篇：
1Z0-053 V13.02 Q523
请登录后发表评论
登录
全部评论
