053-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.

  Since you're running short on time,extend the time-out for the session that's in jeopardy and fix the space problem.Don't put the transaction at risk while you try to find free space and run the commands,and don't kill the transaction-unless you know that the space condition and extended suspend has caused other issues.

posted @ 2017-11-06 23:37  巴啦啦大魔王  阅读(109)  评论(0编辑  收藏  举报