Re: ORacle error upon startup

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Tue, 8 Jun 2004 21:32:59 +0100
Message-ID: <egqxc.105$iC5.94@newsfe5-win>

"Vince Laurent" <vincelaurent_at_sbcglobal.net> wrote in message news:1g6cc0h7r8d6frpmkfrt88anc455d8mad0_at_4ax.com...
> "Oracle instance running on a system with low open file descriptor
> limit. Tune your system to increase this limit to avoid severe
> performance degradation." now appears in the alert log.
>
> (n2)# sysdef | egrep "NAME|ninode|nfile|maxfiles_lim"
> NAME VALUE BOOT MIN-MAX UNITS FLAGS
> maxfiles_lim 1024 - 30-2048 -
> nfile 63498 - 14- -
> ninode 34816 - 14- -
>
> Is the alarm coming from nearing the maxfiles?
> we are running HP-UX11 and Oracle 9.2.0.4
>
> Thanks!
>

whats db_files set to in your pfile or spfile Received on Tue Jun 08 2004 - 15:32:59 CDT