Dennis, I don't think there is an underlying _architectural_ problem (although there could be an OS bug that does not reuse File pointer slots, thus leading to an ever increasing slot usage). MTS would have reduced the _total_ number of open files across the OS by reducing the number of processes that opens files (since they are now shared). Monitoring 'sar -v' on a regular basis (or even writing some scripts that chop up the columns under the 'ov' columns and alert when this is > 0) is a good proactive idea.
John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** >-----Original Message----- >From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] >Sent: Wednesday, June 25, 2003 3:30 PM >To: Multiple recipients of list ORACLE-L >Subject: RE: nfile parameter problem > > >John - Is there some underlying problem with the O.S.? To me >MTS doesn't >make sense on top of an application server that is doing >connection pooling. >I would tend to first suggest reducing the number of >connections the A.S. is >configured for. But I suspect they have performed some study >that tells them >that they need that many connections. I thing Madhu hinted at >that when he >said they weren't handling the current number of connections >well. Maybe the >server is too small or too little memory. Okay, I'm running >pretty thin on >my O.S. expertise here, but something just isn't making sense. >I have a big >server with hundreds of dedicated connections and hundreds of >files, and >don't have this issue. Hopefully I won't encounter it anytime soon. > >Dennis Williams >DBA, 80%OCP, 100% DBA >Lifetouch, Inc. >[EMAIL PROTECTED] > > >-----Original Message----- >Sent: Wednesday, June 25, 2003 4:59 PM >To: Multiple recipients of list ORACLE-L > > >Madhu, > >>I wanted to reduce the open connections by each oracle processes > >As was clearly explained (nay! demonstrated) by Tanel, you >_cannot_ reduce >the open connections as each Db file that contains the >requested block will >be opened by the server process. MTS is one option, but the >basic problem >could be that you have way too many Datafiles... Consolidating >this files >(via CTAS, Export/Import, etc.) will reduce the number of open >files, as >there will be lesser number of files to open. > >John Kanagaraj >Oracle Applications DBA >DB Soft Inc >Work : (408) 970 7002 > >Listen to great, commercial-free christian music 24x7x365 at >http://www.klove.com > >** The opinions and facts contained in this message are entirely mine >and do not reflect those of my employer or customers ** >-- >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). >-- >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: 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).