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

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Fri, 27 Dec 2002 07:28:55 -0800
Message-ID: <F001.0052317A.20021227072855@fatcity.com>

Try:

Force shared connections using (SRVR=SHARED) in the tnsnames.ora.
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 = ).
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: 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).

Received on Fri Dec 27 2002 - 09:28:55 CST