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>让子弹飞一会儿;

上一篇:Echarts项目源代码分析


下一篇:Cookie、Session、Token究竟区别在哪?如何进行身份认证,保持用户登录状态?图文详解