Solution : https://service.sap.com/sap/support/notes/831234 (SAP Service marketplace login required)
Summary :
To resolve ORA-00060 deadlock errors when parallel loading data into BW ODS objects, users can adjust the INITRANS parameter for ODS tables by setting the ORA_ODS_TABLE_INITRANS in RSADMIN. The SAP_RSADMIN_MAINTAIN program facilitates this adjustment, requiring a minor ODS description change to reset INI_TRANS values during the next activation. Verify changes using SQL selections from dba_tables. Corrections are available for BW7 under SP14 (BW7.00) or SP03 (BW7.10) and for earlier BW versions through respective support packages detailed in SAP notes 723258, 723263, and 763340.
Key words :
table_name ini_trans------------------------------ ----------/bic/amyods00 20/bic/amyods40 20/bic/amyods40 20if, sapbwnews bw support package 12 netweaver'04 stack 12, bw operational data store, 10 content import support package 21, 0b import support package 27, '/bic/amyods%', 50 import support package 12, 1 content support package 21, 0b support package 27, ini_trans parameter
Related Notes :
| 901037 | INITRANS parameter after delete operations |
| 763340 | SAPBWNews BW Support Package 12 NetWeaver'04 Stack 12 RIN |
| 750033 | INITRANS parameter for InfoCube secondary indexes |
| 745639 | FAQ: Oracle enqueues |
| 723263 | SAPBWNews BW 3.1 Content Support Package 21 |
| 723258 | SAPBWNews BW 3.0B Support Package 27 |
| 84348 | Oracle deadlocks, ORA-00060 |