Message-ID: <F001.0052317A.20021227072855@fatcity.com>
Date: Fri, 27 Dec 2002 07:28:55 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Khedr, Waleed" <Waleed.Khedr@FMR.COM>
Subject: RE: PMON seems to not close sessions  in a timely manner eg "Max 
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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: Khedr, Waleed
  INET: Waleed.Khedr@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@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).