Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Shared Server Connection 

In a shared server or multithreaded server connection the listener passes the connection request to a dispatcher process that then passes it to one of several shared services in a round-robin least busy methodology. Multiple users share the same server process that connects to the database. For a shared server connection the configuration of the client is identical to the configuration of a dedicated client, the real changes are in the database initialization file.       

Under multi-threaded server there are several server database initialization parameters that must be set properly for MTS to work. These parameters are:

  •    MTS_CIRCUITS.This is a derived value from the value of SESSIONS, defaults to 0 if MTS not configured. The Oracle parameter is CIRCUITS and should be used as this form is deprecated. The CIRCUITS parameter controls the total number of virtual circuits allowed in the database.

  •    MTS_DISPATCHERS.This parameter tells oracle the type and number of dispatchers to create for each network protocol. This parameter becomes DISPATCHERS in Oracle and this new form of the parameter should be used beginning with Oracle release 9.0.1.

  •    MTS_MAX_DISPATCHERS. Sets the maximum number of dispatcher processes to be allowed to run concurrently. In Oracle this becomes MAX_DISPATCHERS, This defaults to 5 but there should be at least one dispatcher for each protocol defined in the MTS_DISPATCHERS parameter. The default value applies only if dispatchers have been configured for the system. The value of MAX_DISPATCHERS should at least equal the maximum number of concurrent sessions divided by the number of connections for each dispatcher. For most systems, a value of 250 connections for each dispatcher provides good performance.

  •    MTS_MAX_SERVERS. Sets the maximum number of shared server processes. In Oracle this becomes MAX_SHARED_SERVERS and defaults to either 20 or to twice the value of SHARED_SERVERS (MTS_SERVERS). If artificial deadlocks occur too frequently on your system, you should increase the value of MAX_SHARED_SERVERS.

  •    MTS_SERVERS. Sets the number of shared connection servers to start when the database is started. Defaults to one on a MTS configured system, 0 on a normal system. In Oracle this becomes SHARED_SERVERS. Oracle will automatically increase this value up to MAX_SHARED_SERVERS so unless you know you will need more than the default leave it set at the default.

See Code Depot


www.oracle-script.com

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.