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

And finally, although I hate asking the question: Why are you running MTS in the first place? I'm not saying there aren't good reasons for it - I'm just curious. Or to be "funny": I've solved many MTS-problems in my time by turning it off. However, that might not be possible or sensible in all cases.

Mogens

Khedr, Waleed wrote:

>Try:
>
>1) Force shared connections using (SRVR=SHARED) in the tnsnames.ora.
>2) Change the service name for the MTS_service and restart te db and
>listener. Make sure the service is registered with the listener. Add a new
>entry pointing to the new service in tnsnames.ora and let you app use this
>entry. I think the entry in tnsnames.ora will need to be like (service_name
>= ) instead of (sid = ).
>3) sqlnet tracing may need to be done.
>
>Regards,
>
>Waleed
>
>-----Original Message-----
>Sent: Friday, December 27, 2002 8:49 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>
>> What do you get when run this on the server hosting Oracle:
>>
>> lsnrctl services
>>
>>
>>
>>
>Waleed, thanks for your input. Here is what I have (below are my MTS
>settings)
>
> MYDB has 1 service handler(s)
> DEDICATED SERVER established:259 refused:1
> LOCAL SERVER
> MYDB has 6 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> DISPATCHER established:2 refused:0 current:2 max:4000 state:ready
> D004 <machine: MYSERVER, pid: 683>
> (ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2276))
> DISPATCHER established:4 refused:0 current:0 max:4000 state:ready
> D003 <machine: MYSERVER, pid: 636>
> (ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2275))
> DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
> D002 <machine: MYSERVER, pid: 534>
> (ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2274))
> DISPATCHER established:1 refused:0 current:1 max:4000 state:ready
> D001 <machine: MYSERVER, pid: 301>
> (ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2273))
> DISPATCHER established:1 refused:0 current:0 max:4000 state:ready
> D000 <machine: MYSERVER, pid: 668>
> (ADDRESS=(PROTOCOL=tcp)(HOST=MYSERVER.MYDOMAIN.com)(PORT=2272))
> DB2 has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
> DB3 has 1 service handler(s)
> DEDICATED SERVER established:0 refused:0
> LOCAL SERVER
>
>#######################################
>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))"
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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).