Quote Originally Posted by PAVB
Have you tested it? I did.
I haven't tested it in Moakes database no. That you tested something in one of your databases and come to a conclusion is an anecdotal which may or may not have any comparison to what is happening here.

i did a quick search on http://asktom.oracle.com and found the following links that seem relevant. I realize that Moakes said he does not have a bitmaped index, but there are probably a few things that if only we knew we would have different suggestions on how to resolve the issue.

I still think that my solution is a practical alternative to more frequent commits, or living with deadlocks. Disagree if you like.

Commits don't help performance.
http://asktom.oracle.com/pls/asktom/...:4951966319022

Bitmaps can cause deadlocks
http://asktom.oracle.com/pls/asktom/...:6042872196732