Re: maximum # of connections per dispatcher

On 6 Apr 2006 16:36:41 -0700, "Joel Garry" <joel-garry@xxxxxxxx>
wrote:

I don't fully understand how it works, it seems to be 'sharing' the
socket somehow between sessions? Let's say I have 4 connections and 16
sessions enabled.. What happens if all 16 sessions want to execute
something? In what wait will that result (if any).

Yeah, it queues up the requests
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c09procs.htm#19358

"In a shared server configuration, a network listener process waits for
connection requests from client applications and routes each to a
dispatcher process. If it cannot connect a client application to a
dispatcher, the listener process starts a dedicated server process, and
connects the client application to the dedicated server. The listener
process is not part of an Oracle instance; rather, it is part of the
networking processes that work with Oracle."

So you must look for lengthening queues and the waits in those views.
After a while, you see dedicated server processes increasing, using up
more memory than anticipated, eventually swapping and making the phone
ring.

I'm no expert in MTS, other than having often thrown it out where
misapplied to OLTP systems. It's a scalability hack - I just get more
capacity.

This is very helpful.. For now I'll just wait for Oracle to produce a
patch.. We've had no problems with the reduced # of dispatchers.

Thanks!

........
We run Oracle 9.2.0.6 on RH4 AMD
remove NSPAM to email
.

Relevant Pages

  • Re: 9.2.0.4 - RHEL3
    ... How can i see how many sessions are also active at that time? ... Do you mean active sessions as in Oracle ... The V$SESSION view shows all existing Oracle connections. ...
    (comp.databases.oracle.server)
  • Re: maximum # of connections per dispatcher
    ... socket somehow between sessions? ... Let's say I have 4 connections and 16 ... If it cannot connect a client application to a ... connects the client application to the dedicated server. ...
    (comp.databases.oracle.server)
  • Re: managing open database links?
    ... none of these ideas can be verified as database link ... connections, but just network and/or instance session connections. ... version of oracle and set up database links as well. ... all machines but the host because there could be client-server sessions out ...
    (comp.databases.oracle.server)
  • ADO.Net Connection Pooling Problem with Oracle
    ... with running out of database connections. ... the number of database sessions in Oracle seem to ... in Oracle from 150 to 300, but we're coming pretty close to this limit. ... database connections everywhere they're used. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection Pooling - tracking users
    ... end-user for connections made through a connection pool where all the sessions use the same Oracle username and show as the OS user of the webserver or application server unless that information is passed to Oracle by the application. ... The Oracle package DBMS_APPLICATION_INFO is sometimes used for this purpose. ...
    (comp.databases.oracle.misc)