Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Session Allocation latch contention - limiting concurrent SQL
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-lReceived on Thu Feb 10 2005 - 03:47:13 CST
![]() |
![]() |