Re: A bunch of sessions costs a lot of memory

Hi

i suppose you use an application server
for your web server like Websphere, Weblogic or MTS all of these offer to you a connection pooling check if its correctly setup and/or
ask your programmer to use it !
your not suppose to have a lot of inactive connection on a web server.

hth
Chris
(sorry for my poor english ;-) )

root <jkotan_at_tconl.com> wrote in message news:<3C419F0F.12964037_at_tconl.com>...
> Zhang,
> Instead, I would look at using Multi-Threaded Server. This will save a
> great deal of memory..
> I would be cautious about killing those sessions, especially when they're
> web server-based.
>
> Yi Zhang wrote:
>
> > We have an Oracle 8i to support web servers. There are about 170
> > sessions keep open and
> > almost 3 GB memory are used by those sessions in this oracle server.
> > My question are:
> > 1, I'm confused that if oracle sessions use large pool in SGA, 3 GB is
> > much larger than SGA we set (600M).
> > 2, Connected sessions are all labled with INACTIVE, can they be killed?
> > 3, How can I limited the sessions to prevent them from unlimited expand?
> >
> > Thanks.
> >
> > Roy
Received on Tue Jan 15 2002 - 22:23:15 CET