> From: Bob Metelsky [mailto:bmetelsky_at_cps92.com]
>
>
> 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"
- 50 max processes? Damn, dude, you're choking that thing to death.
- That is one of the sorriest excuses for a data access methodology that
exists. Tell them to start pooling their database connections or you'll turn
your max processes down even further.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jeremy Pulcifer
INET: Jeremy.Pulcifer_at_kadiri.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).
Received on Tue Dec 24 2002 - 10:33:51 CST
