Re: PMON seems to not close sessions in a timely manner eg "Max processes(50) reached"

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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).