oracle查询死锁的语句

  
--造成死锁的SQL
select A.SQL_TEXT, B.USERNAME, C.OBJECT_ID, C.SESSION_ID, 
       B.SERIAL#, C.ORACLE_USERNAME,C.OS_USER_NAME,C.Process,
       ''''||C.Session_ID||','||B.SERIAL#||''''
from v$sql A, v$session B, v$locked_object C
where A.HASH_VALUE = B.SQL_HASH_VALUE and
B.SID = C.Session_ID

--死锁的对应的进程ID
SELECT distinct OS_USER_NAME, 'alter system kill session '|| '''' || l.SESSION_ID ||',' || s.SERIAL# || '''' ||';'  alterSql
FROM V$LOCKED_OBJECT l,V$SESSION S WHERE l.SESSION_ID=S.SID;

--执行查询出来的死锁进程sql
alter system kill session 'sid,serial#'; 

alter system kill session '2318,6845';
alter system kill session '623,14910';

----fuwq
--spid  
--kill -9 80230
select * from gv$process
where addr in (
select paddr from gv$session where sid  in (SELECT    s.sid 
FROM gv$locked_object l, dba_objects o, gv$session s
WHERE l.object_id　= o.object_id
AND l.session_id = s.sid and object_name in upper('pcdm_singe_project_pack') 
)
)