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