解决oracle数据库 ora-00054:resource busy and acquire with NOWAIT specified 错误

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

 

2. 查询session信息 
SQL> SELECT v.sid,v.SERIAL#,v.USERNAME,v.ACTION FROM v$session v WHERE v.sid IN (SELECT session_id FROM v$locked_object WHERE ORACLE_USERNAME= ‘ATHENA‘) AND V.MACHINE=‘NBCB\KJB-080701N‘; 

3. 杀会话 
语法： 
ALTER SYSTEM KILL SESSION ‘SID,SERIAL#‘; 
例如： 
ALTER SYSTEM KILL SESSION ‘436,62365‘; 

杀完之后再查询，发现sid对应的数据没了，这样就可以啦！实在不行只能重启数据库

解决oracle数据库 ora-00054:resource busy and acquire with NOWAIT specified 错误

标签：alt   res   use   object   客户   导致   ecif   serial   过程