oracle数据库报死锁异常

1.cd /oracle/admin/DBAXJ/bdump 下

2.tail -1000 alert_dbaxj.log |more 查看到ORA-00060: Deadlock detected. More info in file /oracle/admin/DBaxj/udump/DBAXJ_ora_9809.trc 报异常

3. 切换到/oracle/admin/DBaxj/udump/目录下，查看文件DBAXJ_ora_9809.trc

4.文件下查看，找到process对应的2个id

5.sql命令执行，select addr, pid,spid,username,serial# from v$process

6.用sql命令查询spid

select /*+ ORDERED*/ sql_text  from v$sqltext a

where (a.hash_value,a.address) in (

select DECODE(sql_hash_value,0,prev_hash_value,sql_hash_value),

DECODE(sql_hash_value,0,prev_sql_addr,sql_address)

from v$session b

where b.paddr =(select addr from v$process c where c.spid='18364'))

order by piece asc

7.分析查到的SQL语句导致数据库死锁，进行处理（数据库会自动处理死锁）