Re: Session Allocation latch contention - limiting concurrent SQL

From: Mladen Gogala <mgogala@xxxxxxxxxxxxxxxxxxxx>
To: scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx
Date: Thu, 10 Feb 2005 12:58:06 -0500

scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx wrote:

>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. 
>  
>
Session allocation latch? Are you having a CGI application or a web 
application which doesn't
make use application servers and has to connect on every page?

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l

References:

Session Allocation latch contention - limiting concurrent SQL
From: scott . hutchinson

Re: Session Allocation latch contention - limiting concurrent SQL

Other related posts: