orcale异常——oracle操作异常

关闭sessionId

查询session_id 列
select session_id from v$locked_object;
根据session_id 列查出serial#
SELECT sid, serial#, username, osuser FROM v$session where sid = 595;
使用session_id和serial#关闭session
ALTER SYSTEM KILL SESSION '595,622';