Effect of ulimit -s and ulimit -n
ZiaJul 9 2011 — edited Jul 9 2011Hi experts
if anyone could just give me an insight on what would be the effect on the performance of the database if ulimit parameter for open files and stack size are left to default.
in our current database with Solaris 10 and Oracle DB 11gR2, currently these parameters are as under
open files : 256
stack size : 8192
however, the documentation suggests
open files : 4096
stack size : 32768
is it possible default values of these two values will cause the DB to perform dead slow?
regards