Increase no. of connection

As I'm facing problem from Oracle about their SQL*net v1 & v2 hanging. I need to find out whether there is any patch or workaround in AIX to increase the default no of connections on the listen() function call in AIX. The oracle listener uses an operating system function called listen(). The purpose of the listen system call is to listen for socket connections and limit the backlog of incoming connections.

The maximum queue length that the listen() system call can specify is 10.  The maximum queue length is indicated by the SOMAXCONN value in the /usr/include/sys/socket.h file in AIX.

What this means that if 11 customers SIMULTANEOUSLY request a connection 10 connections will be processed and the 11 will be rejected. This does not mean that you can have only 10 SQL*NET connections. When a client requests a connection it first talks to the oracle listener. The oracle listener then gives the client a dedicated server port to connect to. The connection is then dropped with the listener and reconnected with the server processes.(I have simplified this considerably and am using an example not using MTS). So you can see from this that the client is only talking to the listener for a brief time.

On some systems either by upgrading AIX UNIX Operating Systems or applying a patch you can increase the default for the listen() system call. This is something I need you guy whom knew the answer. Current AIX ver is 3.2.5 & Oracle ver is 7.1.3.

The parameter queuesize which is an oracle parameter sets the maximum queue length for the oracle listener. We have found through testing that the maximum value for this parameter is the same as the listen() system call.

Appreciate reply from all. Thanks.

Regards
Jack

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet