Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> USE_SHARED_SOCKET in 9i nt

USE_SHARED_SOCKET in 9i nt

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Fri, 12 Nov 2004 09:35:32 -0400
Message-Id: <4194BC24.000003.01488@DAZA-MGEJCA5J7T>


Hi List, some comment about this parameter in nt Thanks.  

USE_SHARED_SOCKET
You can set parameter USE_SHARED_SOCKET to true to enable use of shared sockets. If this parameter is set to true, the network listener passes the socket
descriptor for client connections to the database thread. As a result, the client does
not need to establish a new connection to the database thread and database connection time improves. Also, all database connections share the port number
used by the network listener, which can be useful if you are setting up third-party
proxy servers.
This parameter only works in dedicated server mode in a TCP/IP environment. If
this parameter is set, you cannot use the 9.0 listener to spawn Oracle7 release 7.x
databases. To spawn a dedicated server for an Oracle database not associated with
the same Oracle home as the listener and have shared socket enabled, you must also
set parameter USE_SHARED_SOCKET for both Oracle homes.  

Here I found an interested answer, some experience?? http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_20847391 html
"Accepted Answer from sudhi
Date: 01/13/2004 05:37AM PST
Grade: A
Accepted Answer  

Amal,  

USE_SHARED_SOCKET could be a performance bottleneck if you have more connections to the database. The load on using the same socket on Windows has been very weak with respect to performance. So the answer would depend on how many simultaneous connections will hit the listener at a point of time. I don't have any benchmark values for this ( there was never a need for this ). But we decided against the use of this with just 50 connections.  

Thanks,
Sudhi."    

Juan Carlos Reyes Pacheco
OCP

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 12 2004 - 07:31:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US