OCP-V13-700

QUESTION 700

701. A user receives the following error while performing a large volume of inserts into a table:

The issue is resolved by increasing the space quota on the USERS tablespace for the user. But the user
may perform such transaction in the future. You want to ensure that the command waits rather than
produce an error when such an event occurs the next time.
What can you do to achieve this before running the command in the future?
这个问题是通过增加空间配额为用户解决用户表空间。但用户
可以在未来进行这样的交易。你要确保命令的等待而不是
当发生这样的事件时产生一个错误。
在未来的运行中，你能做什么来实现这个？

A. Set RESUMABLE_TIMEOUT for the instance

B. Set the RESOURCE_LIMIT Parameter to TRUE.

C. Enable the database instance to use asynchronous commit.

D. Set the LOG_CHECKPOINT_TIMEOUT parameter to a nonzero value for the database instance

Correct Answer: A

当在会话里打开这个功能后(运行 alter session enable resumable timeout 秒,默认7200).当运行某些sql导致空间不足(表空间用完了)、或已抵达该表/段的 maxextents，或者 该用户使用此表空间的配额已经用完（原话：Out of space condition, Maximum extents reached condition, Space quota exceeded condition.），此时Oracle将不会报错，而是把语句挂起，让 dba 在 timeout 所指定的时间范围内解决问题，之后语句又可以继续运行。这个功能主要是防止因为空间不够的原因导致session failed，