Mine is 8.1.7.2 on HP. In init.ora, processes=1000 sessions=1000 mts_servers=8, mts_max_servers=20, dispatcher=10
I have not seen maximum process reached but have seen "Deadlock: MTS Max Servers (20) reached" because applications had more than usual connections once in a while. But that's ok with the applications. Bing -----Original Message----- Sent: Tuesday, December 24, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Well, I had placed the db is MTS mode and still hit the max processes(50) #MTS_DISPATCHERS="(protocol=tcp)(dispatchers=5)(pool=on)(tick=1) (connections=1000)(sessions=4000)" #MTS_MAX_DISPATCHERS=32 #MTS_SERVERS=5 #MTS_MAX_SERVERS=64 #MTS_SERVICE=MYDB #MTS_LISTENER_ADDRESS = "(ADDRESS=(PROTOCOL=TCP)(PORT=1521)(HOST=MYSERVER))" And was able to have only "shared" connections as opposed to "direct" connections EG shows server=shared select username, program, server from v$session where audsid=userenv('sessionid'); I think Ive read all the docs I can find on multi threaded server but did not see anything about creating a service or adding a dispatcher, Im of the understanding that placing the above in my init.ora file, that creates the dispatcher when I bounce the db? In this case as far as I see my MTS service is MYDB.. Eg my SID So, I must be missing something... I'd sincerely appreciate any suggestions ... Examples?? From all the docs I see this is all that's needed, obiviously not - Please advise Thanks bob > > Add a dispatcher, configure MTS, min server processes and add > an Oracle service for this MTS. > > An then let this app connect to Oracle through the MTS service. > > Regards, > > Waleed > > -----Original Message----- > Sent: Tuesday, December 24, 2002 8:54 AM > To: Multiple recipients of list ORACLE-L > processes(50) reached" > > > 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: Bob Metelsky > 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: Khedr, Waleed > 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: Bob Metelsky 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: Wong, Bing 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).