Oracle--锁

 开发者博客：www.developsearch.com

 

 

给某一条记录上锁

select * from ims_ot_user t where t.user_login_name='weihu' for update

 

查看数据库中的锁

SELECT SID, SERIAL# FROM V$SESSION

WHERE SID IN (

SELECT SID FROM V$LOCK

WHERE TYPE IN ('TM','TX')

)

 

查询出所以被锁的会话:

SELECT OBJECT_ID,SESSION_ID,SERIAL#,

ORACLE_USERNAME,OS_USER_NAME,S.PROCESS

FROM V$LOCKED_OBJECT A,

V$SESSION S WHERE A.SESSION_ID=S.SID

 

解锁

alter system kill session '133, 27668';

 

查看数据库中所有的锁

SELECT a.object_id, a.session_id, b.object_name

FROM v$locked_object a, dba_objects b

WHERE a.object_id = b.object_id

 

 

查看数据库中所有的锁的详细信息

select t2.username, t2.sid, t2.serial#, t2.logon_time,a.SQL_TEXT

  from v$locked_object t1, v$session t2, v$sqlarea a

 where t1.session_id = t2.sid

   and t2.prev_sql_addr = a.address

 order by t2.logon_time;

 

开发者博客：www.developsearch.com