Show Table of Contents
11.2. Limiting Maximum Number of Processes Available for the Oracle User
After reading the procedure on, Section 11.1, “Limiting Maximum Number of Open File Descriptors for the Oracle User” you should now have an understanding of "soft" and "hard" limits and how to change shell limits.
To see the current limit of the maximum number of processes for the oracle user, run:
$ su - oracle $ ulimit -u
Note
The
ulimit options are different for other shells.
To change the "soft" and "hard" limits for the maximum number of processes for the oracle user, add the following lines to the
/etc/security/limits.conf file:
oracle soft nproc 2047 oracle hard nproc 16384
To make this change permanent, you could add "
ulimit -u 16384",for bash, to the ~oracle/.bash_profile file which is the user start up file for the bash shell on Red Hat Enterprise Linux (to verify your shell execute echo $SHELL). To do this you could simply copy and paste the following commands for oracle's bash shell:
su - oracle cat >> ~oracle/.bash_profile << EOF ulimit -u 16384 EOF
To make the above changes permanent, you could also set the soft limit equal to the hard limit in
/etc/security/limits.conf:
oracle soft nproc 16384 oracle hard nproc 16384
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.