oracle锁会话

SQL> select * from dba_waiters;

set linesize 200

1.查看锁会话情况
select sid,addr,type,lmode,request from v$lock where request>0 and type <> 'MR'

得到sid

2.查看等待会话、状态和等待时间
col event for a20
col p1text for a20
col p2text for a30
select sid,event,p1text,p2text,state,seconds_in_wait from v$session_wait where sid=

3.查看会话信息
select sid,serial#,username,program,terminal from v$session where sid=

4.查看会话详细
select sql_text from v$sql where address in ( select sql_address from v$session where sid= )

5.操作系统后台kill掉对应进程
select spid from v$process where addr in (select paddr from v$session where sid= )

host kill -9 spid

直接杀死153会话，方法如下：
sys@orcl> alter system kill session '153,18219'; ——'sid,serial#'

[@more@]

========================================
update 行级锁
select addr,xidusn,xidslot,xidsqn from v$transaction;
select xidusn,xidslot,xidsqn,object_id,session_id, oracle_username from v$locked_object;
select addr, sid, type, id1,id2,lmode, request, block from v$lock where sid=1243;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22036495/viewspace-1057622/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22036495/viewspace-1057622/