Dedicated connections on MTS server

From: Aravind Tigadi <ora_aron_at_hotmail.com>
Date: Sat, 09 Jun 2001 09:22:22 -0700
Message-ID: <F001.003232C1.20010609090019@fatcity.com>

Hi,

We have setup a MTS server on our oracle 8.0.5 database. The total number of
>users is around 800 - 900.

Eventough MTS configuration is working fine, we find around 200+ users getting connected to the database as DEDICATED users. According to me If the server is setup as MTS there should not be any dedicated connections going on to database.

My question is

Why my connetions to database are going as DEDICATED...? How do I make sure that all my connections to server are SHARED and not DEDICATED. I have checked my SQLNET.ORA, We do not have use_dedicated_server=on setup on any of the client machines.

Please let me know if you have any answer for this.

TIA, Dan

---

Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Aravind Tigadi
  INET: ora_aron_at_hotmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sat Jun 09 2001 - 11:22:22 CDT