Dedicated vs. Oracle Database Tips by Donald Burleson. The Oracle multithreaded server MTS, later renamed "shared servers" was developed way-back in the days of Oracle7 when RAM was very expensive and RAM region sizes were severely limited by bit technology. Oracle shared servers are also inappropriate for ERP packages that spawn and hold database connections within the application server layer. Bobby Durrett notes that shared servers make sense in rare cases where you have a farm of web servers connecting to your Oracle database, a case where connection pooling makes sense. We have had some outages on the weekend caused by a sudden burst in web server generated database activity. In the past the CPU load would spike and log file sync commit waits would be 20 times slower and we would have to bounce the database and web servers to recover.
Enabling Session Multiplexing
This question is You Asked Hi Tom, How can we know that our database is running on shared mode or dedicated mode. Can we configure the database so that we can change the mode according to our need. Thanks, Snehasish Das. It is not really even a "mode", it is a method of connecting. So, you always have dedicated server connections you need them to start up and shut down and perform other administrative operations. Dedicated server is NOT optional, it is a fact.
Dedicated Server Processes
When building a library in DBCA, there are hints for us to choose the connection type. There are two types: dedicated server mode and shared server mode. The dedicated mode is used by default. As shown below:.
The server process is not shared by any other client. PMON registers information about dedicated server processes with the listener. This enables the listener to start a dedicated server process when a client request arrives and forward the request to it. The following two figures show the basic difference between the shared server connection model and the traditional dedicated server connection model. In the shared server model, a dispatcher can support multiple client connections concurrently. In the dedicated server model, there is one server process for each client. Each time a connection request is received, a server process is started and dedicated to that connection until completed.