11G新特性。

SESSION 1:

SQL> insert into wxh_tbd select * from wxh_tbd where rownum<10;

9 rows created.

SESSION 2:

SQL> alter session set ddl_lock_timeout=10;

Session altered.

SQL> truncate table wxh_tbd;

不會直接報錯，會等待。

超過十秒。報錯：

ERROR at line 1:
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

設定 ddl_lock_timeout來避免truncate 報錯

相關文章