Re: heavy concurrent inserts + buffer busy waits, enquee on ASSM

  • From: LiShan Cheng <exriscer@xxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Wed, 15 Feb 2006 10:39:40 +0100

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
>
>
>

Other related posts: