One thing to remember while running Oracle benchmark clients is to increase the maximum number of processes the user(oracle in this case) can handle on the database server(AIX) side. You can use "ulimit -a" to check the current "max user processes"
To increase the "max user processes" on an AIX server, run smitty -> select System Environments -> select Change / Show Characteristics of Operating System -> Maximum number of PROCESSES allowed per user [600] -> press Enter
isvp14_ora> smitty
To increase the "max user processes" on an AIX server, run smitty -> select System Environments -> select Change / Show Characteristics of Operating System -> Maximum number of PROCESSES allowed per user [600] -> press Enter
isvp14_ora> smitty
Login as user oracle and run "ulimit -a". You will see that the maximum user processes has increased to 600.
3 comments:
Great. Using command you could do the same:
As root run: lsattr -E -l sys0 | grep maxuproc
It will show you the current vallues, e,g: maxuproc 10000 Maximum number of PROCESSES allowed per user True
For changing, say you want to increase to 50000, use the below command as root:
# chdev -l sys0 -a maxuproc=50000
Thank you Saptarshi for the comment, and sharing the information.
Hi What you said is applicable for all users. But i want to increase/decrease number of processes for a particular user. How to achieve this.?
Thank YOu
Post a Comment