Hi,
several times we have some dump with ora-0600 in a our BI system (NW04s, Oracle 10.2 with last patches)
Database error text........: "ORA-00060: deadlock detected while waiting for
resource"
Internal call code.........: "[RSQL/178/XXXX ]"
When we change INIT_TRANS param for tables ... the interuped chains ends fine when we modify the parameter and restart the task.
We have recent SPs
SAP_ABA 700 0014 SAPKA70014
SAP_BASIS 700 0014 SAPKB70014
PI_BASIS 2006_1_700 0004 SAPKIPYM04
ST-PI 2005_1_700 0003 SAPKITLQI3
SAP_BW 700 0016 SAPKW70016
FINBASIS 600 0008 SAPK-60008INFINBASIS
SEM-BW 600 0008 SAPKGS6008
BI_CONT 703 0005 SAPKIBIIP5
ST-A/PI 01I_BCO700 0000 -
With this SPs the problem should be solved with this entry into RSADMIN table.
ORA_CUBEINDEX_INITRANS
ORA_ODS_TABLE_INITRANS
Have you got any idea ? ... we have a nice BI-developer but I prefered to do not leave access with SQLPLUS to server .... can I build a ABAP report to execute "ALTER TABLE "/BIC/FAFC_GL01" INITRANS 20;" to current Oracle istance ? have you got any example ?
Regards.