RE: File Table Overflow on Oracle DB Server

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:VIVEK_SHARMA_at_infosys.com]
> 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: VIVEK_SHARMA_at_infosys.com
>
> 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: ListGuru_at_fatcity.com (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: john.kanagaraj_at_hds.com

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: ListGuru_at_fatcity.com (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).