Home » RDBMS Server » Server Administration » Low open file descriptor (Oracle 9.2.0.6.0 on SunOS 5.9)
Low open file descriptor [message #299343] Mon, 11 February 2008 10:06 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Hi, i was reading an alert_SID.log and i found this msg
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.


when i search in spfile the db_files
i found that is
db_file=1000

and if i count all the datafiles there are 600 datafiles


at last i do

$ ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        8192
coredump(blocks)     unlimited
nofiles(descriptors) 2048
vmemory(kbytes)      unlimited


Does anyone have an idea about where i must search ?
thank you in advance

Re: Low open file descriptor [message #299349 is a reply to message #299343] Mon, 11 February 2008 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is just a warning. 2048 is small for Oracle.
You can ignore this message if you are sure to never exceed this limit.

Regards
Michel
Re: Low open file descriptor [message #299353 is a reply to message #299349] Mon, 11 February 2008 10:56 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Mon, 11 February 2008 10:42
This is just a warning. 2048 is small for Oracle.
You can ignore this message if you are sure to never exceed this limit.

Regards
Michel



Michael, thank you for your quick answer
but... how to i determine the number to use?
i think there must be a way to determine wich is the correct number, or i am wrong?

thank you again

Re: Low open file descriptor [message #299355 is a reply to message #299353] Mon, 11 February 2008 11:15 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Is lsof available on SunOS?

You can list open files with lsof, and count them with something like :

lsof | grep oracle |wc -l

Re: Low open file descriptor [message #299970 is a reply to message #299343] Wed, 13 February 2008 21:46 Go to previous message
suhasbhide
Messages: 9
Registered: February 2008
Junior Member
You can safely increase the nofiles descriptor to 8192. I used to get this error when my datafiles were app. 690. Oracle consulting recommended to raise to 8x of no. of datafiles (use close no. of multiplier of 2) for Oracle Apps. DB.
Previous Topic: Partition
Next Topic: Archive Files filling up
Goto Forum:
  


Current Time: Sun Dec 11 04:04:54 CST 2016

Total time taken to generate the page: 0.20668 seconds