Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to determine the sessions parameter in the pfile

How to determine the sessions parameter in the pfile

From: Walt <walt_at_boatnerd.com.invalid>
Date: Tue, 27 Jan 2004 18:29:57 -0500
Message-ID: <4016F475.FD20601D@boatnerd.com.invalid>

We just put an instance of Oracle 9.2 on W23k on line. So far, so good. It's connected to a webserver farm which uses connection pooling to increase or decrease the number of connections based on load. Unfortunately, at some peak load times the maximum number of sessions is reached and users get the "ORA-00020 : Maximum processes exceeeded" . During those periods, the oracle server doesn't seem to be stressed (low CPU usage, etc.) so I think the problem is just that the processes parameter is artificially low.

So, how does one determine a good value for the processes parameter? I'd like to set it as high as the server will handle, but I'd rather not do this by trial and error.

I've read elsewhere that you should budget 7Meg of memory per process. Is this still true in 9.2?

And if it is, presumably I'd calculate a value for the processes parameter by dividing 7 into the total memory available. What should I use for total memory?
o the total SGA
o the max SGA
o the total RAM of the server
o something else?

Thanks.

-- 

//-Walt
//
//
Received on Tue Jan 27 2004 - 17:29:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US