Re: Increasing value of Max Processes

Actually, it increases the size of the shared pool by maybe 10k or so per process, so you might eat up an additional meg or so. The server creates additional state object structures to accomodate process and session information. Increasing processes also increases the burden on lgwr and pmon, since they have to scan process and session state objects to do their work.

• ricky

TMAN wrote:

> Keith Jamieson wrote:
>
> > What is the effect on Server memory, if I increase the max no of processes
> > by 100.
> >
> > Will this result in the server using an extra 100M of memory?
> > ie 1M of emmory assigned to each process.
>
> No, it will not directly require more memory to up this number. The
> processes parameter only sets the number of operating system user processes
> you allow to connect to an oracle server at the same time. Now with that
> said, if you up this number, the memory required by oracle on the server can
> increase, if there are now more connections coming in to the server. Each
> connection coming in requires X amount of memory to run on the server side.
> X being variable depending on the application or process actually coming in,
> you'll have to examine the memory usage on the server to get that info. I've
> seen processes require as little as 10MB and and much as 120MB (yes we have
> some beast running here). Also be sure to double check your sessions
> parameter if you change the processes parameter.
>
> Thom Crider
Received on Sat Apr 07 2001 - 13:58:35 CDT