| Low open file descriptor [message #299343] |
Mon, 11 February 2008 10:06  |
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
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 #299353 is a reply to message #299349] |
Mon, 11 February 2008 10:56  |
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 #299970 is a reply to message #299343] |
Wed, 13 February 2008 21:46 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
