I have a shell script that opens 80 sessions and updates the same tables. It is different rows. I need to do this, because each update needs to call a procedure that makes an external procedure call to a 3rd party application. We tried doing this with the parallel hint and got the best performance by opening up separate threads and having each thread update separate rows.
This has worked many times in the past. Now I am getting
enq: TX - allocate ITL entry
1. There are not any indexes on the fields being updated
2. I increased the ini_trans to 99. Do I need to do an alter table move for this to full take effect? I just did an 'alter table'
3.
INI_TRANS PCT_FREE PCT_USED FREELISTS FREELIST_GROUPS MAX_TRANS
------------ ------------ ------------ ------------ --------------- ------------
99 10 255
The PCT_FREE=10 is the same as in other databases. where this worked
SEGMENT_SPACE_MANAGEMENT=AUTO. I saw on the web that tables with large numbers of updates run in parallel can have problems with this, but we did not have this problem in other databases?
Edited by: Guess2 on Dec 22, 2011 12:58 PM