There's also a bug with MTS and JDBC Thin connections in 8i, where the dispatchers hang at random intervals. We experienced this on Solaris with 8.1.5 & 8.1.7, even though it was supposedly patched in 8.1.7.
[EMAIL PROTECTED] wrote: > > BP, > > What you are asking falls somewhat into the realm of Black Magic. Will you > see a decrease in resource requirements from Multi Threaded Server (MTS) which > is what I believe your asking. Possibly. It depends on the total number of > connections to your database and the type of transaction these connections > represent. MTS works well for database with a LARGE number of constant > connections, like > 100, that process very short transactions. If these are > batch types of transactions that process a large number of rows at a time then > MTS is not for you. One item that you may have to weigh carefully is what level > of delay can you tolerate in processing a transaction? The reason is that if a > transaction request comes in and there is no shared server available to process > it then it will wait either for a server to free up or Oracle to start a new > one, which is NOT a guarantee. In using MTS I've found the kernel's load > balancing algorithms (those that control the birth and death of shared servers) > to be somewhat erratic and unpredictable. > > Dick Goulet > > ____________________Reply Separator____________________ > Author: "BigP" <[EMAIL PROTECTED]> > Date: 6/12/2002 2:49 PM > > Hi List , > Is there any way I can make shared connectiuon explicitely . When I am looking > at v$session I am finding tons of JDBC connection which are dedicated . Can I > expect some performance gain or low resource requirement out of this if I make > these dedicated connections to shared . > Thanks , > Bp > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > <META content="MSHTML 6.00.2600.0" name=GENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=#ffffff> > <DIV><FONT face=Arial size=2>Hi List ,</FONT></DIV> > <DIV><FONT face=Arial size=2>Is there any way I can make shared connectiuon > > explicitely . When I am looking at v$session I am finding tons of JDBC > connection which are dedicated . Can I expect some performance gain or low > resource requirement out of this if I make these dedicated connections to shared > > .</FONT></DIV> > <DIV><FONT face=Arial size=2>Thanks ,</FONT></DIV> > <DIV><FONT face=Arial size=2>Bp</FONT></DIV></BODY></HTML> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > 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.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
