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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
