QUESTION 160-DBMS_REDEFINITION

To complete the online redefinition procedure, you execute the following command;

EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (‘SH’, ‘SALES’, ‘INT_SALES’, 600);

What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

 

A. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.

B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.

C. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.

D. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

Correct Answer: D

 

Now you can specify a lock timeout in number of seconds during which time FINISH_REDEF_TABLE attempts to acquire an exclusive lock for swapping the source and interim tables and, if timeout expires, the operation exits.
现在，您可以在数秒内指定锁定超时，在此期间完成对源和临时表交换的独占锁定，如果超时过期，则操作退出。

This feature increases the flexibility of FINISH_REDEF_TABLE to exit after waiting a user-specified number of seconds so that the user does not wait indefinitely or needs to force exit of the online redefinition session.

这个特性增加了FINISH_REDEF_TABLE在等待用户指定的秒数后退出的灵活性，这样用户就不会无限期地等待或者需要强制退出在线重新定义会话。

Oracle 12c数据库已经引入了对DBMS_REDEFINITION的增强，用于指定一个锁定超时(以秒为单位)，这将允许FINISH_REDEF_TABLE获得对源和临时表交换的独占锁。如果超时过期，则操作退出。这将有助于避免用户取消或无限期等待。这并没有将我们的会话放在队列中，下面的示例将显示该会话