Oracle-L: Re: dedicated sessions

From: Yechiel Adar <adar76_at_inter.net.il>
Date: Tue, 18 Jun 2002 01:53:19 -0800
Message-ID: <F001.00480058.20020618015319@fatcity.com>

Hello Bp

The topic was discussed on the list some time ago. The trade off seems to be memory vs. CPU. If I recall correctly MTS use more resources and dedicated connection use about 3MB for each connection on NT.

Yechiel Adar
Mehish

Original Message ----- From: BigP To: Multiple recipients of list ORACLE-L Sent: Thursday, June 13, 2002 12:49 AM Subject: dedicated sessions

  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

--

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

Author: Yechiel Adar
INET: adar76_at_inter.net.il

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 Tue Jun 18 2002 - 04:53:19 CDT