Re: Oracle spwaned server process

From: Jeremiah Wilton <jeremiah_at_wolfenet.com>
Date: Fri, 30 Oct 1998 13:04:30 -0800
Message-ID: <Pine.OSF.3.95.981030125346.32651A-100000@gonzo.wolfenet.com>

On 30 Oct 1998, Yanfeng Feng wrote:
>
> Is there anyway to change the size of server process for each
> Oracle session. I am using AIX4.1, each server process takes
> about 5M. It's too much for our system, we have 1300 process and
> only 2gig of memeory.

It sounds like you are a prime candidate for using MTS, the multithreaded server. With MTS, you can have several sessions share small pool of shared server processes. Requests and network I/O are brokered by special processes called dispatchers.

--
Jeremiah Wilton http://www.wolfenet.com/~jeremiah Received on Fri Oct 30 1998 - 15:04:30 CST