Why not just increase max processes? Jared
On Tuesday 24 December 2002 05:53, Bob Metelsky wrote: > I have a developers stored procedure making repeaded calls > (logons/request for data and logoff) > Each call takes only seconds but it seems like PMON dosnt close the > process in a timely manner, leaving what look to be ghost process. If a > few users hit the same app the processes go to = 50 then I get the > dreaded "ORA-nnn max processes (50) reached" > > I can "watch" processes increse and decrese with v$session and > v$process, they just dont seem to close quick enough. (however, they do > eventually close) > > Any ideas what to look for. Ive searched Google and for parameters for > PMON to no avail, hence I bring my delimma to the list > > > I think I'd like to tell PMON how frequently to check for completed > requests. > > thanks and happy holidays > bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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).