oracle分区表死锁,ORACLE RAC 出现的表死锁问题

简单描述一下,单位用的生产数据库是ORACLE RAC(HP UNIX 11i)

在数据库一个节点中的日志文件出现如下错误提示(alert_oradb1.log)

Mon Dec  4 17:33:45 2006

Global Enqueue Services Deadlock detected. More info in filen /app/oracle/produc

ts/9.2/rdbms/log/oradb1_ora_2000.trc.

Mon Dec  4 17:33:52 2006

Global Enqueue Services Deadlock detected. More info in filen /app/oracle/produc

ts/9.2/rdbms/log/oradb1_ora_2000.trc.

然后在oradb1_ora_2000.trc中的错误提示是:

*** 2006-12-04 17:33:45.208

user session for deadlock lock c0000001548ccde8

pid=221 serial=35263 audsid=3101488 user: 165/WLSPCF

O/S info: user: , term: , ospid: 1234, machine: hqwls01

program:

Current SQL Statement:

DELETE PCF_TOKEN WHERE TOKEN_ID = :B1

Global Wait-For-Graph(WFG) at ddTS[0.149] :

BLOCKED c000000164456b80 4 [0x8eb6][0x0],[TM] [131378,570] 1

BLOCKER c0000001548ccde8 4 [0x8eb6][0x0],[TM] [65757,100] 0

BLOCKED c0000001548ccde8 4 [0x8eb6][0x0],[TM] [65757,100] 0

BLOCKER c000000164456b80 4 [0x8eb6][0x0],[TM] [131378,570] 1

user session for deadlock lock c0000001548ccde8

pid=221 serial=35263 audsid=3101488 user: 165/WLSPCF

O/S info: user: , term: , ospid: 1234, machine: hqwls01

program:

Current SQL Statement:

DELETE PCF_TOKEN WHERE TOKEN_ID = :B1

Global Wait-For-Graph(WFG) at ddTS[0.14a] :

BLOCKED c0000001548ccde8 4 [0x8eb6][0x0],[TM] [65757,100] 0

BLOCKER c00000015de1a340 4 [0x8eb6][0x0],[TM] [131232,1666] 1

BLOCKED c00000015de1a340 4 [0x8eb6][0x0],[TM] [131232,1666] 1

BLOCKER c0000001548ccde8 4 [0x8eb6][0x0],[TM] [65757,100] 0

出现很多这样的错误(在oradb1_ora_2000.trc中),在数据库中出现这样的错误,大家谁见过,

是不是前台的应用也出现会出现的错误提示啊,影响应用啊?

还有谁在数据库机群中遇到过这样的错误?

出现这样的错误是应用程序本身的问题,还是数据库机群的问题啊?

大侠们给看看吧！小弟在这里先谢谢了!