nfile parameter problem

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Wed, 25 Jun 2003 09:36:49 -0700
Message-ID: <F001.005B9595.20030625085004@fatcity.com>

Hello All,
We have Oracle ( 8.1.7 ) running on HP-UX and experiencing HP-UX Error: 23: File table overflow errors , so initially we have bumped the nfile kernel parameter to 128 K. Just couple of days back we have seen the same problem and database crashed. Glance Plus shows us that Oracle processes are opening lot of files. some Oracle processes are opening over 400 files. I have a sample shown below and open files at this moment is 87396 out of 128010. During the peak hours open files are reaching 100K plus.

My main question to you all is : Is there any way to reduce the # of open files opened by Oracle processes ??

We have some java processes ( which are really worst ) opens lot of dedicated connections using thin drivers , can it be handled in a better way like using the THICK driver or MTS ??

I definitely need your inputs

HP-UX ds0000 B.11.00 A 9000/800 06/25/03

10:37:29 text-sz ov proc-sz ov inod-sz ov file-sz ov 10:37:30 N/A N/A 1173/16404 0 3829/15000 0 87396/128010 0

Thank You,
Madhu Reddy
X13944

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Reddy, Madhusudana
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). Received on Wed Jun 25 2003 - 11:36:49 CDT