MTS works with SQL*Net2 as well as Net8. I used it with a 7.3.4
database, with SQL*Net2 and the shared connections were jdbc
connections from the app
- Paul Li <paul.li_at_sanchez.com> wrote:
> MTS only work through NET8?? So, it is no helpful for JDBC
> connection???
>
> Thanks
>
> -----Original Message-----
> Sent: Thursday, June 13, 2002 10:23 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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).
>
>
>
>
> This electronic mail transmission contains confidential and/or
> privileged
> information intended only for the person(s) named. Any use,
> distribution,
> copying or disclosure by another person is strictly prohibited.
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Paul Li
> INET: paul.li_at_sanchez.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).
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Mon Jun 17 2002 - 10:18:24 CDT