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!

increase of processes/session parameter

user511621Nov 24 2010 — edited Nov 24 2010
we have hpux server 11.23 wiht 4 processor and 16 gb ram

os parameter maxuprc is set to 409

we have 3 10g databases and 5 11g databases

processes and sessions parameters for each database is 150 and 170 respectively

so total is 150*8=1200 and 170*8=1360

most of the time we are getting

ORA-12518: TNS:listener could not hand off client connection error.

i think increasing processes/sessions parameter will solve this problem but i want to knw how it affects os if i m increase this parameter or on what criateria i can increase above parameters.

Please suggest.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 22 2010
Added on Nov 24 2010
8 comments
956 views