Solution : https://service.sap.com/sap/support/notes/84348 (SAP Service marketplace login required)
Summary :
This SAP Note addresses the occurrence of ORA-00060 errors indicating deadlocks during resource waits, primarily attributed to application-level programming flaws rather than Oracle itself. The issue arises when parallel scripts attempt to lock numerous records within the same database block, leading to space allocation failures for additional locks. This situation transforms row-level locks into block-level locks, potentially leading to deadlocks if locks are not managed efficiently. A careful examination of Oracle trace files can pinpoint the direct causes and the specific locked objects contributing to the deadlock. Recommendations include inspecting and potentially increasing the INITRANS parameter values for tables and indexes to alleviate block-level lock contention and adjusting transaction concurrency settings.
Key words :
] [2018-0blocker 700001045976bd8 5 wq 1 cvtops x8 [0x4c0028][0x70a4], blocked 700001045976e78 5 wq 2 cvtops x1 [0x4c0028][0x70a4], /oracle/<sid>/saptrace/background/alert<sid>, directory /oracle/<sid>/saptrace/usertrace, deadlocks checking unique key violation, default initrans valueat table level, obj - rowid = 000018c2 - 0001012d, terms ora-60 ora-000060 reason, obj - rowid = 000016f2 - 0003bc42, free interested transaction list
Related Notes :
| 1608273 | Deadlock on D342L and D345T |
| 1108581 | DIMP: Error ORA-00060 - deadlock detected for table CPZP |
| 1044110 | INITRANS for InfoCube indexes in BW 7 |
| 851980 | Deadlock occurs when transaction dependent MRP is called |
| 845823 | Deadlock on tables MDVM/DBVM/J_3AMRPR/MDKP for AFS Solution |
| 831234 | Deadlock ORA-00060 during parallel loading into BW ODS |
| 821687 | FAQ: Space utilization and fragmentation in Oracle |
| 750033 | INITRANS parameter for InfoCube secondary indexes |
| 745639 | FAQ: Oracle enqueues |
| 634458 | ODS object: Activation fails - DEADLOCK |
| 584416 | Guidelines for the ALPHA conversion on oracle databases |
| 543470 | CO object: Performance improvement for totals record update |
| 541538 | FAQ: Reorganization |
| 492812 | Deadlocks on table SOXP |
| 145647 | F110: Performance and deadlocks in payment program |
| 95200 | Cash managmt and forecast: deadlock on FDSB or FDSR |