RE: nfile parameter problem

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).