Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Determine the value for the "Processes" parameter

Ed CharterNov 29 2016 — edited Nov 29 2016

Hi,

We just upgraded from Oracle 11.2.0.4 (SE) to 11.2.0.4 (EE). In the standard edition we always ran into issue with number of processes maxed out(ORA-00020: maximum number of processes exceeded). I am reading some online documents that talks about the formula to set the value for "processes", "sessions", and "transactions" parameter values. Please see the following formula and let me know if this how the value for "processes" parameter is set in Oracle? Secondly, is there a max limit for "Processes" parameter? If you need any more information to help me or answer my question, please set me know.

processes=pc
sessions=pc*1.5+22
transactions=sessions*1.1

thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 27 2016
Added on Nov 29 2016
5 comments
3,063 views