Oracle 锁Lock

发布时间：2020-12-12 13:54:00 所属栏目：百科来源：网络整理

导读：https://blog.csdn.net/qq_27317147/article/details/52048770 select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id = lo.object_i

https://blog.csdn.net/qq_27317147/article/details/52048770 select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode from v$locked_object lo,dba_objects ao,v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; --1 1726 2404 ZGGL Administrator KPMG_SUBJ_LIST_HIGHEST 3 select spid,osuser,s.program from v$session s,v$process p where s.paddr=p.addr and s.sid=1726; alter system kill session '1726,2404' immediate; --1 5160 1726 2404 ZGGL select a.spid,b.sid,b.serial#,b.username from v$process a,v$session b where a.addr=b.paddr and b.status='KILLED'; select b.spid,a.osuser,b.program from v$session a,v$process b where a.paddr=b.addr and a.sid=1726; select spid,v$process p where s.paddr=p.addr and s.sid=1718; select sess.sid,v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; select spid,v$process p where s.paddr=p.addr and s.sid=1718; alter system kill session '1718,2404' immediate; select spid,v$process p where s.paddr=p.addr and s.sid=1726; --1 1718 217 BSDUSR stevenxu KPMG_JOURNAL 3 select sess.sid,v$session sess where ao.object_id = lo.object_id and lo.session_id = sess.sid; select name from v$database; alter system kill session '1718,217' immediate; --1 1360 1718 217 BSDUSR select a.spid,v$session b where a.addr=b.paddr and b.status='KILLED'; --1 1360 stevenxu ORACLE.EXE (SHAD) select b.spid,v$process b where a.paddr=b.addr and a.sid=1718; --1 1360 stevenxu SQL Developer select spid,v$process p where s.paddr=p.addr and s.sid=1718; orakill DATALAKE 1360 C:UsersAdministrator>orakill datalake 1306 Kill of thread id 1306 in instance datalake successfully signalled.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!