Re: 7.3.4 on NT4 SP4 kills Listener?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 9 Jul 1999 13:18:57 +0200
Message-ID: <931519098.11452.0.pluto.d4ee154e@news.demon.nl>

This would result in 190 times 2 times 1 Mb sort_area_size also. I have a feeling , and probably you should like in the listener.log NT gets saturated and the listener is unable to create dedicated sessions. In previous versions of Oracle for NT Multithreaded Server was not supported. AFAIK this has been changed. With that number of users it should be interesting to look in that area, and convert to MTS

Hth,

Sybrand Bakker, Oracle DBA

Forest <tempest3_at_usa.net> wrote in message news:3788d492.92661770_at_netnews.att.net...
> We're running a proprietary tracking application on 7.3.4 with NT4
> SP4. Box is a Compaq 5500 w/ 4 Zeon P400 and 1GB of RAM. DB runs
> archive log mode, parallel query disabled, shared pool = 80MB, sort
> area = 1MB. Oracle73 service uses 300mb initially and bloats between
> 870MB - 980MB during the course of the day. - Ouch!
>
> Problem - proprietary app client logins range from 130 - 190 which
> utilizes 2 sessions for each; does this pose an issue for NT not being
> able to handle these concurrent sessions and increase potential for NT
> to kills Listener? The Listener was stopped previously during
> production hrs, though not sure of cause.
>
>
Received on Fri Jul 09 1999 - 06:18:57 CDT