database check finish with warnings

[Former Member]

Dear all

Please guide how can resolve this warings

oracle 9.2.0.7 ,oprating system windos 2003 advanced server sap ECC5

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_6080.trc.

BR0976W Database message alert - level: ERROR, line: 108900, time: 2007-08-29 19.57.47, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [65], [65], [], [], [], [], []

BR0976W Database message alert - level: WARNING, line: 108901, time: 2007-08-29 19.57.47, message:

ORA-00060: deadlock detected while waiting for resource

BR0976W Database message alert - level: WARNING, line: 108904, time: 2007-08-29 19.57.51, message:

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_5992.trc.

BR0976W Database message alert - level: ERROR, line: 108908, time: 2007-08-29 19.57.51, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [61], [61], [], [], [], [], []

BR0976W Database message alert - level: WARNING, line: 108909, time: 2007-08-29 19.57.51, message:

ORA-00060: deadlock detected while waiting for resource

BR0976W Database message alert - level: WARNING, line: 109228, time: 2007-08-30 10.10.44, message:

ORA-000060: Deadlock detected. More info in file d:\oracle\prd\saptrace\usertrace\prd_ora_4212.trc.

BR0976W Database message alert - level: ERROR, line: 109232, time: 2007-08-30 10.10.44, message:

ORA-00600: internal error code, arguments: [kdtdelrow-2], [65], [65], [], [], [], [], []

tahnks in advanced

with reagrds

venkat

[Former Member]

go for patchset 9.2.0.8 and the latest minipatch (currently 9.2.0.8.10).

deadlocks are normaly application specific and not database related. the ORA-000060 only indicates that the Oracle database prevents a deadlock (two or more transactions locking each other)

Peter