RE: PMON seems to not close sessions in a timely manner eg "Max

From: Wong, Bing <bing.wong_at_IngramMicro.com>
Date: Tue, 24 Dec 2002 10:48:44 -0800
Message-ID: <F001.00521D52.20021224104844@fatcity.com>

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: bmetelsky_at_cps92.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Khedr, Waleed
> INET: Waleed.Khedr_at_FMR.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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: bmetelsky_at_cps92.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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wong, Bing
  INET: bing.wong_at_IngramMicro.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 - 12:48:44 CST