Press "Enter" to skip to content

oracle之报错:ORA-00054: 资源正忙,要求指定 NOWAIT

SQL> select session_id from v$locked_object;

SESSION_ID
----------
142

SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 142;

SID SERIAL# USERNAME OSUSER
---------- ---------- ------------------------------ ------------------------------
142 38 SCOTT LILWEN

SQL> ALTER SYSTEM KILL SESSION '142,38';

System altered

SQL> conn scott/tiger@vm_database
Connected to Oracle Database 11g Enterprise Edition Release 11.1.0.6.0
Connected as scott

SQL> drop table student2;

Table dropped

Be First to Comment

发表评论

电子邮件地址不会被公开。 必填项已用*标注