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.