Oracle-L: Re: dedicated sessions

From: Suzy Vordos <lvordos_at_qwest.com>
Date: Thu, 20 Jun 2002 09:59:47 -0800
Message-ID: <F001.0048300D.20020620095947@fatcity.com>

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.

dgoulet_at_vicr.com 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" <big_planet_2000_at_hotmail.com>
> 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: dgoulet_at_vicr.com
>
> 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: 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.com
-- 
Author: Suzy Vordos
  INET: lvordos_at_qwest.com

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: 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 Jun 20 2002 - 12:59:47 CDT