| why ? [message #98916] |
Wed, 17 September 2003 00:34  |
Thanh
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Errors in file bdump/lgwr_2109.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: 'redo01.log'
ORA-27041: unable to open file
Linux Error: 23: Too many open files in system
Additional information: 2
LGWR: terminating instance due to error 313
|
|
|
|
| Re: why - Too many open files in system [message #98935 is a reply to message #98916] |
Wed, 05 November 2003 23:21  |
Frank Naude
Messages: 4589
Registered: April 1998
|
Senior Member |
|
|
Hi,
View your /proc/sys/fs/file-max file to get the current "open files" limit for your system. If you want to set it (e.g. 65536) type:
"echo 65536 >/proc/sys/fs/file-max"
You can also check your High-Water-Mark in the /proc/sys/fs/file-nr file. There are 3 numbers, the first is your high-water-mark, the second are your actually open file and the third is the file-max-entry.
Best regards.
Frank
|
|
|
|
| Re: why - Too many open files in system [message #98991 is a reply to message #98935] |
Thu, 19 February 2004 08:21 |
Robert Mijango
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
Hi,
this just happened to me. I increased the fs.file-max from the default 8192 to 10240.
I am running PostgreSQL on an Intel P4 with 3GB of RAM. How can I calculate what would be a good file-max without overallocating resources?
Regards,
Robert Mijango
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
