Hi,
I am using ODP.NET and doing some array INSERT ( using OracleCommand.BindArrayLength and arrays as parameters ) in parallel threads to the same database table,,using up to 50 rows to insert at once ( parametwer array length )
1. I am not inserting any duplicatesof unique constraint.
2. I have set INITRANS of the used Partition to the number of parallel threads that are INSERTING
3. I am not using any BITMAP index
4. The lock type is ' enq: TX - row lock contention '....mode of the lock is 6, and the request of the lock is 4.
4. By looking into v$lock, v$session and v$active_session_history, I can find the sessions involved in this, I can find the SQL that is using the deadlock..but always ROW_WAIT_OBJ#, and also, CURRENT_OBJ# is -1...so I am not sure which object is locked....somewhere I found that it could be also the splitting of the index that could cause the locking and then a dead lock
5. How could I find what is the reason for this lock / dead lock...to be 100% sure..... ?
thx
Aleksandar