ASSM and high volume concurrent inserts

From: "Haroon A. Qureshi" <haroon_a_qureshi@xxxxxxxxx>
To: Oracle-L@xxxxxxxxxxxxx
Date: Thu, 17 Dec 2009 09:46:38 -0800 (PST)

Hello,

A client is running an application that does high volume concurrent inserts (> 
200million rows).  Performance degrades with high buffer busy waits.  The 
tablespace is ASSM managed, so we can't change the freelists to tune it.  I 
want to try moving to a manually managed tablespace and tune the freelists.  
But not sure if the client will go for that change, given the effort and 
timelines.  Has anyone come across performance issues with ASSM and high volume 
inserts?  Anyway of tuning it with ASSM?

Thanks in advance,
Haroon
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: ASSM and high volume concurrent inserts
From: Mark W. Farnham

Re: ASSM and high volume concurrent inserts
From: Surachart Opun

ASSM and high volume concurrent inserts

Other related posts: