Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Session Allocation latch contention - limiting concurrent SQL

Session Allocation latch contention - limiting concurrent SQL

From: <scott.hutchinson_at_interact-analysis.com>
Date: Thu, 10 Feb 2005 10:14:33 +0000
Message-ID: <1108030473.420b3409b1c3a@mopp.namemagic.com>


I have a problem where I can not increase the number of concurrent SQL statements running through our system. I believe this is caused by contention on the SESSION ALLOCATION latch while internal stats are being updated.

The highest number of SQL statements I can run is 30,000 per second. I am running SAP code to migration many millions of customers into SAP, so we are limited with the number of code changes we can make. I've set timed_statistics to false and statistics_level to basic. I see very high values in V$LATCH.WAIT_TIME for this latch(**per second**:60000 Gets, 22000 Misses, 17000 Spin gets, 5000 sleeps, 12 secs Wait time).

Does anyone have suggestions (other than RAC) for ways to overcome this? The DB server has 32 CPUs, and we have 9 application severs running the code (with a total of 96 CPUs).

Thanks,
Scott Hutchinson
Interact Analysis Ltd

::This message sent using the free Web Mail service from http://TheName.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 10 2005 - 03:47:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US