ORA-00060: Deadlock detected

原创 2015年11月19日 10:07:48

Thu Nov 19 01:13:49 2015
ORA-00060:Deadlock detected. More info infile
/u01/oracle/diag/rdbms/appserv/appserv/trace/appserv_ora_20577.trc.

去查看相应的trace文件appserv_ora_20577.trc的死锁信息

PS:相应的trc文件中的内容比较多建议要看下响应报错的时间点要吻合

*** 2015-11-19 01:13:48.592
DEADLOCK DETECTED ( ORA-00060 )
 
[Transaction Deadlock]
 
The following deadlock is not an ORACLE error. It is a
deadlock due to user error in the design of an application
or from issuing incorrect ad-hoc SQL. The following
information may aid in determining the deadlock:
 
Deadlock graph:
                       ---------Blocker(s)--------  ---------Waiter(s)---------
Resource Name          process session holds waits  process session holds waits
TX-00090002-00030b2f        67     629     X             66     601           X
TX-000b0009-00147b59        66     601     X             67     629           X
 
session 629: DID 0001-0043-00000011 session 601: DID 0001-0042-000004C5 
session 601: DID 0001-0042-000004C5 session 629: DID 0001-0043-00000011 
 
Rows waited on:
  Session 629: obj - rowid = 00016255 - AAAZfqAAJAAElQvAAZ
  (dictionary objn - 90709, file - 9, block - 1201199, slot - 25)
  Session 601: obj - rowid = 00016255 - AAAZfqAAJAAElStAAV
  (dictionary objn - 90709, file - 9, block - 1201325, slot - 21)
 
----- Information for the OTHER waiting sessions -----
Session 601:
  sid: 601 ser: 941 audsid: 3082107 user: 88/STAT_HOLLYCRMAPP
    flags: (0x41) USR/- flags_idl: (0x1) BSY/-/-/-/-/-
    flags2: (0x40009) -/-/INC
  pid: 66 O/S info: user: oracle, term: UNKNOWN, ospid: 12644
    image: oracle@appserv172.szgas.com
  client details:
    O/S info: user: Administrator, term: unknown, ospid: 1234
    machine: CALLCENTER246 program: JDBC Thin Client
    application name: JDBC Thin Client, hash value=2546894660
  current SQL:
  delete call_rec where 1=1  and row_date >= to_date('2015-11-18','yyyy-MM-dd')  and row_date < to_date('2015-11-19','yyyy-MM-dd') 
 
----- End of information for the OTHER waiting sessions -----
 
Information for THIS session:
 
----- Current SQL Statement for this session (sql_id=1mp3bsu6ggr12) -----
delete call_rec where 1=1  and segstart >=  1447884000 and segstart < 1447898400
===================================================

 

根据trc信息,查询:

SQL> select addr,pid,spid,username,serial# from v$process t where t.PID in (67,66);

 
ADDR          PID SPID    USERNAMESERIAL#
----------------                     ----- ------- --------------- ----------
00000003CA391AF0 66 12644    oracle   248
00000003C8365EB8 67 20577     oracle    14
SQL> select sid,serial#,paddr from v$session k where k.PADDR in ('00000003CA391AF0',
'00000003C8365EB8') ;
  2  
       SID    SERIAL# PADDR
---------- ---------- ----------------
       601  941 00000003CA391AF0
       629 2821 00000003C8365EB8
SQL> select SID, STATUS FROM v$session where SID=601;   


       SID STATUS
---------- --------
       601 INACTIVE


SQL> 


INACTIVE状态的会话表示此会话处于非活动、空闲、等待状态。

ORACLE对于这种情况一般会自动处理,但如果频繁报错就需要应用去改了








版权声明:本文为博主原创文章,未经博主允许不得转载。

相关文章推荐

DEADLOCK DETECTED (ORA-00060)Trace实例分析

DEADLOCK DETECTED (ORA-00060)Trace实例分析Oracle中引入的行级锁的概念,在大幅提高性能的同时也带来了一点麻烦。对于设计不良或者说处理不当的应用逻辑,有可能出发死锁...
  • heicm
  • heicm
  • 2011年05月09日 16:24
  • 853

ORA-00060 Deadlock detected

今天一套10.2.0.4的数据库报ORA-00060 Deadlock detected。   trace部分内容:   Dump file /oracle/oracle/product/10...

版本压缩(Compress)提示"ORA-00060: deadlock detected while waiting for resource".

当我们对版本数据进行Compress操作时,可能会碰到Oracle的错误:"ORA-00060: deadlock detected while waiting for resource". ...

What to do with "ORA-60 Deadlock Detected" Errors [ID 62365.1](oracle deadlock 学习资料-05.1)

Deadlock trace file 解读

ruby MOESI_CMP_directory Invalid RubyRequestType和Possible Deadlock detected. Aborting!错误

参考: https://www.mail-archive.com/gem5-users@gem5.org/msg08744.html  (解决问题一) http://thread.gmane.org...

ORACLE死锁(ORA-00060)故障排查的一般性手法

ORACLE死锁(ORA-00060)故障排查的一般性手法 【背景】 今晨巡检发现SAP PRD产生一个死锁: Sun Jun 29 10:30:36 2014 O...
  • fenyu8
  • fenyu8
  • 2016年12月23日 16:18
  • 589

死锁(ora-00060)以及死锁相关的知识点

最近碰到一个死锁的问题:ora-00060 deadlock detected while waiting for resource  (ora-00060 等待资源时检测到死锁)   查看udu...

ORA-00060的示例与若干场景

create table eg_60 ( num number, txt varchar2(10) ); insert into eg_60 values ( 1, 'First' ); inse...
  • bisal
  • bisal
  • 2013年11月06日 16:49
  • 2161

ORA-04091变异表 ora-00060

一般解决这种问题有两种办法:
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ORA-00060: Deadlock detected
举报原因:
原因补充:

(最多只允许输入30个字)