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 [EMAIL PROTECTED] -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 _ 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: MacGregor, Ian A. 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).
Re: Dedicated connections on MTS server
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).
RE: Dedicated connections on MTS server
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).