Skip to Content
0
Apr 08, 2008 at 05:16 PM

INI_TRANS changes on BI system

161 Views

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.