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

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

Re: Session Allocation latch contention - limiting concurrent SQL

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 10 Feb 2005 12:58:06 -0500
Message-ID: <420BA0AE.6060706@allegientsystems.com>


scott.hutchinson_at_interact-analysis.com 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
Received on Thu Feb 10 2005 - 13:00:51 CST

Original text of this message

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