Re: Connection Blues, Solaris

In article <336ABB95.6468_at_san.rr.com>, "Lane W. Sharman" wrote:

The only question that I have for you is why are you using MTS? I assume that you have over 200 users+processes. If you do not, then I think that you will see an increase in performance. MTS has a considerable overhead by having the PGA in the shared_pool, and not against the user process. The concurrency processes which Oracle employ for MTS do not become effective until you have a reasonable number of users (200+)

just me 2p's worth.

Neil_Chandler_at_stratus.com

>Hi Everyone,
>
>Well, here is my tale of woe. ANY and ALL input is appreciated in
>advance. I manage a fairly large online web community, flirt.com, and
>have transferred it to a netra i-140. The problem is that I cannot get
>listener.ora to run any pre-spawned threads without hanging connections.
>With pre-spawning and MTS, the multi-threaded server, connections ought
>to be like lightening. Well, they are fast when they work but they hang
>every couple of connections. This would be the ideal set up according to
>the docs: a dispatcher pool within the instance and the listener
>pre-positioning connection threads per connection request. Is there a
>patch/upgrade to make this work? Environment:
>
>Platform=netra i/140
>OS=Solaris 2.5.1
>Oracle=7.3.2, Workgroup Server
>Application Library=DBI/DBD running on server
>Memory=192MB
>
>When I remove the threads, of course, the system works properly; the
>connections become reliable, but simultaneous requests get serialized
>leading to unacceptable wait times.
>
>Also, is there a memory leak, severe or mild, in this version of the
>OCI?
>
>Here is listener.ora (some values etched out to protect the innocent):
>
>LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = TCP)
> (Host = xx.yyy.zz.qqq)
> (Port = 1521)
> (QUEUESIZE=80)
> )
> )
>
>STARTUP_WAIT_TIME_LISTENER = 0
>CONNECT_TIMEOUT_LISTENER = 100
>TRACE_LEVEL_LISTENER = OFF
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = rrrr)
> (ORACLE_HOME = /opt/oracle7)
> (PRESPAWN_MAX = 80)
> (PRESPAWN_LIST=
> (PRESPAWN_DESC=(PROTOCOL=tcp) (POOL_SIZE=20) (TIMEOUT=10))
> )
> )
> )
>
>--
>Lane Sharman
>Pour chasser le chagrin,
>il faut du vin.
Received on Wed May 07 1997 - 00:00:00 CDT