-- 锁表
select l.session_id sid,s.serial#,l.LOCKED_MODE,
l.ORACLE_USERNAME,l.OS_USER_NAME,s.MACHINE,s.TERMINAL,
o.OBJECT_NAME,s.LOGON_TIME
from v$locked_object l,all_objects o,v$session s
where l.OBJECT_ID=o.OBJECT_ID
and l.SESSION_ID=s.SID
order by sid,s.SERIAL#
select * from TTransSerial for update
--
-- 查询哪些表被锁了
SELECT /*+ rule */ s.username,
decode(l.type,'TM','TTransSerial LOCK',
'TX','ROW LOCK',
NULL) LOCK_LEVEL,
o.owner,o.object_name,o.object_type,
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser
FROM v$session s,v$lock l,dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT Null
-- 解锁
alter system kill session 'sid,serial#'
select l.session_id sid,s.serial#,l.LOCKED_MODE,
l.ORACLE_USERNAME,l.OS_USER_NAME,s.MACHINE,s.TERMINAL,
o.OBJECT_NAME,s.LOGON_TIME
from v$locked_object l,all_objects o,v$session s
where l.OBJECT_ID=o.OBJECT_ID
and l.SESSION_ID=s.SID
order by sid,s.SERIAL#
select * from TTransSerial for update
--
-- 查询哪些表被锁了
SELECT /*+ rule */ s.username,
decode(l.type,'TM','TTransSerial LOCK',
'TX','ROW LOCK',
NULL) LOCK_LEVEL,
o.owner,o.object_name,o.object_type,
s.sid,s.serial#,s.terminal,s.machine,s.program,s.osuser
FROM v$session s,v$lock l,dba_objects o
WHERE l.sid = s.sid
AND l.id1 = o.object_id(+)
AND s.username is NOT Null
-- 解锁
alter system kill session 'sid,serial#'
alter system kill session '153,23072'