Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> "low open file" at solaris

"low open file" at solaris

From: zhu chao <zhuchao_at_gmail.com>
Date: Thu, 16 Dec 2004 13:58:13 +0800
Message-ID: <962cf44b04121521582ee7cae9@mail.gmail.com>


Hi, all,

    I believe many people are running oracle 9i on solaris platform. Does anyone noticed this message while starting oracle instance at solaris:
"Wed Dec 15 21:00:06 2004

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

  According to metalink, os parameter "open files" (rlim_fd_max at solaris?) need to be tuned as formular: 2*db_files + controlfile+logfile ..., if my db_files=1000, then I have to set rlim_fd_max to near 2400. Without changing this parameter, will there really be some performance degradation?

If I reduce the db_files to 100 or so, then no warning any more.

Thanks.

-- 
Regards
Zhu Chao
www.cnoug.org
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 16 2004 - 00:09:08 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US