tuning maximum number of processes?
2007-12-25 5:30:00
Our Oracle DBA says he is limited to only having 128 processes. As part of
performance testing, he would like this value increased to 512. The /etc/system
file has an entry for "set maxuprc = 128". maxusers has not been set.
What's the best way to adjust the max number of processes per user? Should I
increase maxuprc directly, or should I adjust maxusers and see how the change
trickles down? Other?
On Solaris 9, how do I view the maximum process limits in effect for a given
user? Before I make any changes, I want to verify the before/after behavior.
And finally, how do I view the current value of max_nprocs to make sure I don't
tune the max processes for one user (maxuprc) beyond the max processes of the
entire system (max_nprocs)?
System is a V440, 4xCPUs, 16-GB RAM, Solaris 9
Thank you! I will summarize.
-John
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
Comments
Got something to say?
You must be logged in to post a comment.
