R - I haven't yet been the victim of .net (thankfully), and I hope someone with direct experience will reply. But just in case, I'll mention a couple of ideas. Try to sample the SQL that is being inflicted on Oracle. Microsoft interfaces tend to have default settings for the lowest common denominator (like accessing a flat file). I've seen them do stuff like pull the entire table over just to verify that it hasn't changed. This sort of thing can usually be corrected by using other than default settings.
Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, January 30, 2003 7:15 AM To: Multiple recipients of list ORACLE-L 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? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).