Dennis, Thanks for reply We are using Oracle 9iAS and connection pool is configured to open 360 simultaneous connections out of which we are using only 120 with two java containers. now itself we are getting lot of issues with this java code and I am not sure where we going to land up with its full utilization ( 360 connections ) .
I wanted to reduce the open connections by each oracle processes Madhu Reddy X13944 -----Original Message----- Sent: Wednesday, June 25, 2003 12:15 PM To: Multiple recipients of list ORACLE-L Madhu On the Java side, are they using an application server (like Oracle9i AS or Weblogic or Tomcat?). If not, suggest that they should. If they are, there are connection pool settings that control how many connections will be opened. I have had test databases nailed by that one. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Wednesday, June 25, 2003 11:50 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS 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: 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).
