Oracle之资源正忙和标记要终止的会话

1>select session_id from v$locked_object;

2>select sid, serial#, username, osuser from v$session where sid = 1.session_id;

3>alter system kill session '2.sid, 2.serial';

4>select spid, osuser, s.program from v$session s, v$process p where s.paddr = p.addr and s.sid = 1.session_id;

5>在linux上，kill -9 4.spid;

6>让子弹飞一会儿；