1.查到SID.SELECT SESSION_ID FROM V$LOCKED_OBJECT,USER_OBJECTS WHERE V$LOCKED_OBJECT.OBJECT_ID=USER_OBJECTS.OBJECT_ID ;
2.查到SERIAL#.SELECT SERIAL# FROM V$SESSION WHERE SID=‘SESSION_ID’ ,
3.alter system kill session 'sid,SERIAL#'
报错:ERROR at line 1:
ORA-00031: session marked for kill
4.select spid, osuser, s.program from v$session s,v$process p where s.paddr=p.addr and s.sid=24
切换ROOT用户
kill -9 spid
但错误仍然有。
结果是有个JOB在执行。