I'm fighting this same problem, but in reverse.
I'm trying to get all my folks using DEDICATED connections.
Simply put on my server the listener uses port 1521 for MTS/shared
connections. It uses port1529 for DEDICATED connections. The
TNSNAMES.ORA file on each client determines which port is
used.
If you simply & REALLY want to preclude your users from
connecting as DEDICATED session, then simply remove that
port from the listener.ora file & bounce the listener. If/when
the listener no longer accepts connections for the dedicated
port, all your users will be forced to use MTS.
FWIW - When I switched from MTS to DEDICATED
my nightly batch jobs went from 5 hours of run time to
about ONE hour of runtime.
HTH & YMMV!
Aravind Tigadi wrote:
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
