| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: nfile parameter problem
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).
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). Received on Wed Jun 25 2003 - 15:11:02 CDT
 |
 |