First, if in tnsnames.ora file on the client alias group contains
srvr=dedicated or in sqlnet.ora there is a parameter server=dedicated (or
something like this) - you will have dedicated connection. Second if your
maximum number of shared servers in init.ora less then number of users
trying to connect in the same time for part of users which is the difference
between these numbers connection will be dedicated and record will be
written into alert.log (at least I see this behavior on 7.3.4).
Alex Hillman
-----Original Message-----
Sent: Saturday, June 09, 2001 1:00 PM
To: Multiple recipients of list ORACLE-L
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: Hillman, Alex
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).
