解决表死锁

--查看被锁的对象
SELECT * FROM V$LOCKED_OBJECT;
--查看被锁对象
select object_name as 对象名称, s.sid, s.serial#, p.spid as 系统进程号
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr;

SELECT /*+ RULE */
LS.OSUSER OS_USER_NAME,
LS.USERNAME USER_NAME,
DECODE(LS.TYPE,
'RW',
'ROW WAIT ENQUIRE LOCK',
'TM',
'DML ENQUIRE LOCK',
'TX',

'TRANSACTION ENQUIRE LOCK',
'UL',
'USER SUPPLIED LOCK') LOCK_TYPE,
O.OBJECT_NAME OBJECT,
DECODE(LS.LMODE,
1,
NULL,
2,
'ROW SHARE',
3,

'ROW EXCLUSIVE',
4,
'SHARE',
5,
'SHARE ROW EXCLUSIVE',
6,
'EXCLUSIVE',
NULL) LOCK_MODE,
O.OWNER,
LS.SID,
LS.SERIAL# SERIAL_NUM,
LS.ID1,
LS.ID2
FROM SYS.DBA_OBJECTS O,
(SELECT S.OSUSER,
S.USERNAME,
L.TYPE,
L.LMODE,
S.SID,
S.SERIAL#,
L.ID1,
L.ID2
FROM V$SESSION S,
V$LOCK L
WHERE S.SID = L.SID) LS
WHERE O.OBJECT_ID = LS.ID1
AND O.OWNER<> 'SYS'
ORDER BY O.OWNER, O.OBJECT_NAME;

--处理
alter system kill session '48,49704' immediate;