| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Dedicated connections on MTS server
You enable MTS on the server and that method becomes the default connection method, but the final determination on whether shared or dedicated servers are used is controlled on the client side.
If a client's tnsnames file has server=dedicated as part ofn the stanza for connecting to the database, the conenction is going to be a dedicated one.
Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu
-----Original Message-----
Sent: Saturday, June 09, 2001 10:00 AM
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
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: ian_at_SLAC.Stanford.EDU 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:42:43 CDT
 |
 |