RE: Multithreaded server - effect of POOLING=ON option

From: Sinardy Xing <SinardyXing_at_bkgcomsvc.com>
Date: Tue, 11 Nov 2003 23:54:26 -0800
Message-ID: <F001.005D6591.20031111235426@fatcity.com>

Hi Peter,

pooling is for:
user that connected but idle will be disconnected temporary for new incoming or outgoing request.

ON or BOTH or YES or TRUE is to turn on OFF or FALSE or NO is default to turn off IN for incoming connection only
OUT for outgoing connection only

Sinardy  

-----Original Message-----
Sent: 12 November 2003 13:04
To: Multiple recipients of list ORACLE-L

Hi Peter,

There are many parameters for this particular option:

ON, OFF, YES, NO, IN, OUT, TRUE, FALSE, BOTH (not even sure I've exhausted the entire list here)

Used for connection pooling, the values you choose for this parameter impact your idle network connections.

For more info, feel free to check out this link:

http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/mts.htm#453787

hth,
melanie

• "Schauss, Peter" <peter.schauss_at_ngc.com> wrote:
  > Thanks for all of the input on the multi-threaded
  > server. I have one
  > more question:
  >
  > What is the effect of the POOLING option on the
  > MTS_DISPATCHERS
  > specification?
  >
  > Thanks,
  > Peter Schauss
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Schauss, Peter
  > INET: peter.schauss_at_ngc.com
  >
  > 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: 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!?
Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Melanie Caffrey
  INET: melanie_caffrey_at_yahoo.com

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: 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.net
-- 
Author: Sinardy Xing
  INET: SinardyXing_at_bkgcomsvc.com

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: 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 Wed Nov 12 2003 - 01:54:26 CST