首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

ORA:00054 处置

2012-08-22 
ORA:00054 处理ORA-00054: resource busy and acquire with NOWAIT specified对于这个问题解决,可以有两种

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.对于第二种方法,需要补充,执行步骤如下:a、以sysdba身份登陆数据库,connect ***/***@*** as sysdbab、从视图v$session中查找状态为inactive的SID,select status, sid, serial# from v$sessionc、使用命令kill状态为inactive的session,alter sysmen kill session '<sid>,<serial>'

热点排行