强制杀掉ORACLE中进程.doc

ORA-00031: session marked for kill 处理Oracle中杀不掉的锁 一些ORACLE中的进程被杀掉后，状态被置为killed，但是锁定的资源很长时间不释放，有时实在没办法，只好重启数据库。现在提供一种方法解决这种问题，那就是在ORACLE中杀不掉的，在OS一级再杀。1.下面的语句用来查询哪些对象被锁：select object_name, machine, s.sid, s.serial#  from v$locked_object l, dba_objects o , v$session swhere l.object_id　=　o.object_id and l.session_id=s.sid; /////////// select v$lock.sid, v$session.SERIAL#, v$process.spid, v$session.machine, ctime, block b, v$session.PROGRAM, decode(v$lock.type, MR, Media Recovery, RT, Redo Thread, UN, User Name, TX, Transaction, TM, DML, UL, PL/SQL User Lock, DX, Distributed Xaction, CF, Control File, IS, Instance State, FS, File Set, IR, Instance Recovery, ST, Disk Space Transaction, TS, Temp Segment, IV, Library Cache Invalida-tion, LS, Log Start or Switch, RW, Row Wait, SQ, Sequence Number, TE, Extend Table, TT, Temp Table, Unknown) LockType, rtrim(object_type) || || rtrim(owner) || . || object_name object_name, decode(lmode, 0, None, 1, Null, 2, Row-S, 3, Row-X, 4, Share, 5, S/Row-X, 6, Exclusive, Unknown) LockMode, decode(request, 0, None, 1, Null, 2, Row-S,