First, introduction
MTS (MULTI-Threaded Server) is an optional configuration selection of Oracle Server. It is relative to Dedicate. Its biggest advantage is to support more concurrent connections in the premise that do not have to increase physical resources (memory). In other words, if you only have 2G physical memory, you want to support 2000 connections, you should choose MTS under the premise of getting the best performance.
This article first said that MTS's way of working, then compares with the Dedicate method, then let's talk about the specific configuration of the MTS, and finally say some to optimize the MTS configuration option.
Second, MTS work mode
1. Joseph C. Johnson gives a metaphor of an MTS image in a restaurant
Suppose Oracle is a restaurant, when you walk into a restaurant, you feel the most comfortable service method is a special Waiter to serve you, regardless of how many people come in the restaurant, she only requests you, this is Dedicte Treatment, that is, every Oracle client has a dedicated service process to serve it. The way most of the restaurants are not one-on-one. When you walk into the time, you are specified for a waiter, and she may also be other of the table, which is the most favorable for the restaurant. Because they can serve more guests without increasing their employees. This may also be good for you. If the restaurant is not too busy, the request for her serve is very short and easy to complete, your feelings seem to have a special Waiter, Waiter turns your ORDER to the chef Then put the good dishes, this is the way MTS handles, these shared waiters we call them to Dispatcher, and the chef us call them for Shared Server Processes.
2, tell the MTS's way of work (one of the Sybex book)
1) Client Send a service request to dispatcher
2) Dispatch puts this request in the request of the SGA area
3) Processing this request by one or several service processes
4) The service process puts the result of the DISPATCH in the response queue of the SGA area of the Dispatch.
5) Dispatcher picks the result from the response queue
6) Complete the client's request and send the result to the client
Third, the MTS is compared to the Dedicate method, and the following briefs are drawn.
Serial number
Comparison
MTS mode
Dedicate method
1 Service Process Multiple Connections Sharing a Service Process One Connection has a dedicated service process
2 The amount of memory used for each client is 3-4m 150-200K
3 Suitable application environment Suitable for a lot of connections and a very short OLTP environment If the resources of the Oracle server are enough, this way is preferred 4 CPU loads cause some CPU load. If your CPU has bottleneck, don't use this Species
