ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q519(DBMS_RESUMABLE.SET_SESSION_TIMEOUT)

Oracle OCP 1Z0 053 Q519(DBMS_RESUMABLE.SET_SESSION_TIMEOUT)

原创 Oracle 作者:abstractcyj 时间:2016-04-04 12:59:22 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    833932