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
ulimitoptions 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
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_profilefile 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
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
oracle soft nproc 16384 oracle hard nproc 16384