Yea, hash partition the table into 4 to 16 partitions. If feasible of course. Otherwise freelists is your only bet. On 2/15/06, The Human Fly <sjaffarhussain@xxxxxxxxx> wrote: > > Hello List, > > We have solved log file sync issue and received another issue with > heavy concurrent inserts. We have couple of tables used for heavy > inserts and they are in tablespace which is LMT and ASSM. I was in a > expressiong that ASSM will solve the concurrent insert issues of > buffer busy wait by automatic freelist management. But, in our case, > we still get this problems. > Moving those couple of tabels to a tbs with Manual freelist management > defining freelist group as 3 and freelist as 7 or 9 value as storage > value to those tables. > > Is ther any other option that we can solve concurrent inserts issue? > > -- > Best Regards, > Syed Jaffar Hussain > 8i,9i & 10g, OCP DBA > Banque Saudi Fransi, > Saudi Arabia > http://jaffardba.blogspot.com/ > > ---------------------------------------------------------------------------------- > "Winners don't do different things. They do things differently." > -- > //www.freelists.org/webpage/oracle-l > > >