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

[Mogens Nørgaard]

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