ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

EODA@PROD1> drop table t purge;drop table t purge           *ERROR at line 1:ORA-00054: resource busy and acquire with NOWAIT specified or timeout expiredEODA@PROD1> select t2.username,t2.sid,t2.serial#,t2.logon_time   --查询阻塞事务from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time; USERNAME      SID    SERIAL# LOGON_TIM------------------------------ ---------- ---------- ---------EODA       50 771 18-OCT-16EODA@PROD1> select sql_text from v$session a,v$sqltext_with_newlines b  --查询阻塞的语句  where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value  and a.sid=&sid order by piece;  Enter value for sid: 50old   3:   and a.sid=&sid order by piecenew   3:   and a.sid=50 order by pieceSQL_TEXT----------------------------------------------------------------BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;EODA@PROD1> alter system kill session '50,771';  --kill事务System altered.EODA@PROD1> drop table t purge;Table dropped.