Vivek, The database backend process will open the file on your behalf, and each open takes up one entry in your 'Numbe of Open files in the System' OS table. Not many people monitor the output of 'sar -v'. Look for overflows of some of the OS tables under the 'ov' column... (this will also indicate the amount of overflow).
John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Disappointment is inevitable, but Discouragement is optional! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED] > Sent: Monday, February 24, 2003 3:29 AM > To: Multiple recipients of list ORACLE-L > Subject: File Table Overflow on Oracle DB Server > > > > > We have the following query reg. an error on HP-UX ORacle DB server. > > > > We are encountering "HPUX Error: 23: File table overflow'" on the > > Oracle database server while executing stress tests for our > > application. We are not opening any files on the database server > > through the application still this error keeps coming after running > > the test for some duration. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
