RE: Middle Tier spawning sessions, possible performance issues

Anjo,  

Actually I saw this in your (et al) famous YAPP paper.  

Still curious,
Steve   

-----Original Message-----
Sent: Thursday, January 30, 2003 10:32 AM To: Multiple recipients of list ORACLE-L

I read somewhere that for apps that constantly logon/logoff (like web apps), one possible thing to do is increase the cache size for the AUDSES$ sequence. Anyone done this and seen improvements?

Curiously,
Steve Orr

-----Original Message-----
Sent: Thursday, January 30, 2003 9:15 AM To: Multiple recipients of list ORACLE-L

You are kind of on the right track. The number of sessions doesn't really matter. What matters is that they logon/logoff all the time. That is the worst thing that you can do in an Oracle database. Why? The session will allocate the cursors, parse them, close them everytime the session will logon/logoff. The symptoms that you will see. Latch contention (shared pool,

library cache), shared pool fragmentation etc.

Anjo.

On Thursday 30 January 2003 05:14, rgaffuri_at_cox.net wrote:
> I'm far more of a developer than a DBA, but when someone told me this it
> set off a big red light in my head.
>
> We are using an Oracle Backend with a .net front front. One of our .net
> guys told me that the middle tier they are using 'spawns' sessions.
>
> We have 2 pretty distinct skillsets here so fixing the middle tier is
> probably way beyond my pervue. However, they told me that in a recent
demo,
> the performance degraded overtime. Its my understanding that generally
this
> is caused by one of two things.
>
> 1. Failure to use Bind Variables... we are using them everywhere.
>
> 2. Too many sessions.
>
> Am I on the right track here? How much would shared server mode help? This

> may be an enormous issue since they are expecting 250 contiguous users.
> Another option I tossed around was moving as much logic from the client
> side to the database to avoid the session spawning. I know that generally
> this is a good idea, but its difficult when the database people are lousy
> in C# and the .net people our lousy in PL/SQL and SQL.
>
> Any opinions?

-- 
---------------------------------------------------------------- 
Anjo Kolk 
http://www.oraperf.com <http://www.oraperf.com>  

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Anjo Kolk 
  INET: anjo_at_oraperf.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>  
San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Orr, Steve
  INET: sorr_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).