--查看死锁语句
select sql_text from v$sql where hash_value in (select sql_hash_value from v$session where sid in (select session_id from v$locked_object))
--查看死锁进程
SELECT s.username,l.OBJECT_ID,l.SESSION_ID,s.SERIAL#,l.ORACLE_USERNAME,l.OS_USER_NAME,l.PROCESS
FROM V$LOCKED_OBJECT l,V$SESSION S
WHERE l.SESSION_ID=S.SID;
--杀掉死锁
alter system kill session '734,19125'
alter system kill session '763,11495'
--killed 的杀除
select a.spid,b.sid,b.serial#,b.username from v$process a,v$session b where a.addr=b.paddr and b.status='KILLED'
select spid, osuser, s.program from v$session s,v$process p where
s.paddr=p.addr and s.sid=39
c:\orakill hr 17624