OraFAQ Forum: Linux » Oracle instance running on a system with low open file descriptor limit

Home » Infrastructure » Linux » Oracle instance running on a system with low open file descriptor limit (Linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle instance running on a system with low open file descriptor limit [message #423310]

Wed, 23 September 2009 05:34

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

In my alert log, i am getting following errors:

WARNING:Oracle instance running on a system with low open file descriptor limit. Tune your system to increase this limit to avoid severe performance degradation.

select count(*) from dba_data_files;
count(*)
---------
43

ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 139263
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

[root@dbprod ~]# ulimit -n
1024

[root@dbprod ~]# uname -a
Linux dbprod 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:32:14 EDT 2005 i686 i686 i386 GNU/Linux

Thanks in advance

Report message to a moderator