Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> USE_SHARED_SOCKET in 9i nt
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-lReceived on Fri Nov 12 2004 - 07:31:47 CST
![]() |
![]() |