"low open file" at solaris

  • From: zhu chao <zhuchao@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Dec 2004 13:58:13 +0800

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
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  • » "low open file" at solaris