519.You notice that a long-running transaction is suspended due

分类: 英语题型 发布时间: 2023-12-01 12:13 浏览量: 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.

正确答案是B