ORA_CUBEINDEX_INITRANS

[Former Member]

which is the correct value for parameter ORA_CUBEINDEX_INITRANS in table rsadmin?

I have a deadlock during insert in fact table

thanks

alessandro cherchi

[Former Member]

We have had problems with deadlocks as well, but it turned out to be related to bitmap indexes rather than the initrans settings which was the first thing we examined.

If it is related to concurrent attempts to update the bitmap indexes, the best thing to do is drop the indexes before loading. You would want to do this for load performance reasons any way.

[Former Member]

thanks

I haven't read

"The standard value will be 2 and you should increase the parameter (perhaps in tens steps) until the deadlock no longer occurs."

Alessandro

[Former Member]

Hi Alessandro,

remember that when you ask a question you also assume the responsibility to assign points!

See: /people/mark.finnern/blog/2004/08/10/spread-the-love

All the best !

Roberto

[Former Member]

Wow !!!

[Former Member]

Hi Alessandro,

check the OSS Note 750033 'INITRANS parameter for InfoCube secondary indexes' in which your problem is described with a related solution.

Hope it helps !

Bye,

Roberto