Oracle-L: Middle Tier spawning sessions, possible performance issues

From: <rgaffuri_at_cox.net>
Date: Thu, 30 Jan 2003 05:14:47 -0800
Message-ID: <F001.0053E68C.20030130051447@fatcity.com>

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.

Failure to use Bind Variables... we are using them everywhere.
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?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: <rgaffuri_at_cox.net
INET: rgaffuri_at_cox.net

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). Received on Thu Jan 30 2003 - 07:14:47 CST