« Linux Oracle tuning parameter : Message queues | Main | Linux vs. Oracle Tuning, Error : ORA-00845: MEMORY_TARGET not supported on this system »
Linux Oracle tuning parameter : ulimits
By Martin | June 5, 2009
To view current settings, run command:
ulimit -a
To set it to a new value for this running session, which takes effect immediately, run command:
ulimit -n 8800
ulimit -n -1 // for unlimited; recommended if server isn’t shared
Alternatively, if you want the changes to survive reboot, do the following:
- Exit all shell sessions for the user you want to change limits on.
- As root, edit the file /etc/security/limits.conf and add these two lines toward the end:
oracle soft nofile 16000
oracle hard nofile 20000
** the two lines above changes the max number of file handles – nofile – to new settings.
- Save the file.
- Login as the user1 again. The new changes will be in effect.
Topics: Uncategorized | No Comments »
Trackback URL for this post: http://www.bearparc.info/2009/06/05/linux-oracle-tuning-parameter-ulimits/trackback/
Comments
You must be logged in to post a comment.





























