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_at_gmail.com> 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."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 15 2006 - 03:39:40 CST
