rasing maxuprc value - dependencies ?

[henrik bartels_1]

Hello !

We have system (HP-UX 11.11) where the kernel parameter maxuprc is set to 320 and now we have problem with to many database connections and the system can't fork more processess for that user. I have countinously raised these parameter but I'am not aware of consequences of rasing this to much - are there any important dependencies that should be considered ?

regards/
Henrik

[Thierry Poels_1]

hi,

Database tend to have a rather high maxuprc (1024 is not abnormal) because one user (install user) will own all the processes.

Next to maxuprc, nproc should be set high enough (follow up with "sar -v").

regards,
Thierry.

[Vijaya Kumar_3]

Hi
I think it is not an issue. Try to run Oracle instances using different user accounts...

For example, orauser1 runs oradb1 database. orauser2 runs oradb2 database etc.

Thanks
Vijay

[T G Manikandan]

Maxuprc should be less than the nproc value

maxuprc-->user limit no. of processes
nproc-->total number of processes on the system.

http://docs.hp.com/hpux/onlinedocs/939/KCParms/KCparam.MaxUprc.html

[Sridhar Bhaskarla · Accepted solution]

Hi Henrik,

Other than that maxuprc should be less than nproc (SAM will not alow to configure it ofcourse), there isn't much I would worry about raising this parameter. If your application requires it, then you can. However, just keep track of what is happening on the system. A bad script or program can fork numourous child processes unnecessarily.

-Sri

[henrik bartels_1]

thank you all/
Henrik