wyd_2822285的博客

Oracle报 ORA-00054资源正忙的解决办法来源于：http://www.cnblogs.com/loveLearning/p/3625544.htmloracle之报错:ORA-00054: 资源正忙，要求指定 NOWAIT问题如下：SQL> conn scott/tiger@vm_databaseConnected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0Connected as sc.

begin for R in (select table_name AS tname from user_tables) loop execute immediate 'analyze table '|| R.tname ||' compute statistics'; null; end loop;end;/SELECT * FROM USER_TABLES where num_rows = 0