Quote Originally Posted by mjschwenger
Changing pctfree = 15 brought me a little bit lower insert rate - 4%, but may be it's not related only to pctfree - just such stage after 10mln of records inserted.
Tested also initran = although I do not have too many updates, the number of enq: TX - index contention increases if I drop them to 40.
Calculating hwm and changing it up will allocate a lot of space per segment - I have 140 freelists x 50 for hwm = 7000 blocks...
Let me try and I'll post my results.
Please, advise what other changes I could test.
Thanks a lot,mj
Post the full statspack report taken 5 min interval here.

Tamil