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