USE_SHARED_SOCKET in 9i nt

  • From: "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Nov 2004 09:35:32 -0400

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

Other related posts:

  • » USE_SHARED_SOCKET in 9i nt