Oracle 锁表 锁表查询 结束锁表进程

1.   Oracle 锁表

locktable表名字inexclusivemode;

所记录： select * from 表名字  for update

2.   Oracle 锁表查询

selectb.owner,b.object_name,a.session_id,a.locked_mode

from v$locked_objecta,dba_objects b

where b.object_id = a.object_id;

3.    Oracle锁表查看是哪个session引起的

select b.username,b.sid,b.serial#,logon_time

from v$locked_objecta,v$session b

where a.session_id =b.sid order by b.logon_time;

4.       查看连接工具

SELECT substr(v$lock.sid,1,4) "SID",serial#,V$SESSION.sid,

       substr(username,1,12)"UserName",

       substr(object_name,1,25)"ObjectName",

       v$lock.type"LockType", 

      decode(rtrim(substr(lmode,1,4)),

       '2','Row-S (SS)','3','Row-X(SX)',

       '4','Share',     '5','S/Row-X (SSX)',

       '6','Exclusive', 'Other' )"LockMode",

      substr(v$session.program,1,25) "ProgramName"

FROM V$LOCK,SYS.DBA_OBJECTS,V$SESSION

WHERE (OBJECT_ID = v$lock.id1

      AND v$lock.sid = v$session.sid

      AND username IS NOT NULL

      AND username NOT IN ('SYS','SYSTEM')

      AND SERIAL# != 1);

5.       杀会话 结束锁表进程

altersystemkillsession'sid,serial#';