查询oracle 死锁2

   SELECT *FROM v$process p WHERE p.sPID=10841
   SELECT *FROM v$session s WHERE s.paddr='00000402DB738740'
   SELECT *FROM v$session v WHERE v.process ='10841'
   SELECT *FROM v$process WHERE addr='00000402DB6DBE20'
   SELECT *FROM v$session a WHERE sid= 1213
   SELECT *FROM v$sqltext a WHERE a.HASH_VALUE='2850782796' ORDER BY 4   

-- 从数据库一已知的SESSION_ID号，查回ERP系统中的请求
SELECT fcr.ORACLE_PROCESS_ID --UNIX进程号(oragdprd 用户)
      ,fcr.oracle_session_id --
      ,fcr.OS_PROCESS_ID --UNIX进程号(appgdprd 用户)
      ,fu.USER_NAME
      ,fcr.request_id
      ,fcr.parent_request_id
      ,fcpv.USER_CONCURRENT_PROGRAM_NAME
      ,fcr.PHASE_CODE --'R' 表示处于运行阶段   --'C' 表示正常完成   --'P' 表示处于待定阶段.
      ,fcr.STATUS_CODE --'R' 表示处于运行状态   --'C' 表示正常完成   --'X' 表示处于取消或终止状态.
      ,fcr.REQUESTED_START_DATE
      ,fcr.ACTUAL_START_DATE
      ,fcr.last_update_date
--,fcr.*
  FROM FND_CONCURRENT_REQUESTS    fcr
      ,FND_CONCURRENT_PROGRAMS_VL fcpv
      ,FND_USER                   fu
      ,v$session                  s
      ,V$PROCESS                  p
 WHERE fcr.CONCURRENT_PROGRAM_ID = fcpv.CONCURRENT_PROGRAM_ID
   AND fcpv.APPLICATION_ID = fcr.PROGRAM_APPLICATION_ID
   AND fcr.REQUESTED_BY = fu.USER_ID
   AND (fcr.PHASE_CODE = 'R' OR fcr.STATUS_CODE = 'R')
   AND s.PADDR = p.ADDR
   AND p.SPID = fcr.Oracle_Process_Id
   AND s.sid = 490
 ORDER BY fcr.last_update_date DESC

-----查询holder sid
SELECT DECODE(request, 0, 'Holder: ', 'Waiter: ') || sid sess
      ,id1
      ,id2
      ,lmode
      ,request
      ,TYPE
  FROM V$LOCK
 WHERE (id1, id2, TYPE) IN (SELECT id1
                                  ,id2
                                  ,TYPE
                              FROM V$LOCK
                             WHERE request > 0)
 ORDER BY id1
         ,request
------查询session信息，如果是form应用一般不会超过1天时间，是的话直接删除
SELECT *FROM v$session WHERE sid=&sid
------查询lock sql
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))

------kill session