ORA:00054 处置
日期：2014-05-16 浏览次数：20394 次
ORA:00054 处理
ORA-00054: resource busy and acquire with NOWAIT specified
对于这个问题解决，可以有两种方式：
1)COMMIT or ROLLBACK will release locks of the current user
2)If its really locked and the commit suggestions don't work, get the SID and
SERIAL# fields from v$session and issue a ALTER SYSTEM KILL SESSION command.
This sometimes takes a while as Oracle has some cleaning up to do, but the
object is eventually freed.
2)If its really locked and the commit suggestions don't work, get the SID and
SERIAL# fields from v$session and issue a ALTER SYSTEM KILL SESSION command.
This sometimes takes a while as Oracle has some cleaning up to do, but the
object is eventually freed.
对于第二种方法，需要补充，执行步骤如下：
a、以sysdba身份登陆数据库，connect ***/***@*** as sysdba
b、从视图v$session中查找状态为inactive的SID，select status, sid, serial# from v$session
c、使用命令kill状态为inactive的session，alter sysmen kill session '<sid>,<serial>'
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
