mcclnx mcc wrote:
We have CEntos 5.5 on DELL server. Due to more and more databases run on same server sometime processes number read max and cause 'resource temporary unavailable".
I plan to change /etc/security/limits.conf value:
oracle soft nproc 2047 ==> 4096
Do i need reboot to make it effect?
How to test change is effect?
Google for tuning linux for oracle. Here's a good tutorial with recommendations.
http://labite.wordpress.com/2012/08/31/tuning-linux-server-for-oracle-database/
You should really talk to Oracle, or Dell, for that matter, about performance tuning for Oracle. If you're still under warranty, They'll give you good numbers.
mark