MTS (multi-threaded server) is an optional configuration choice for Oracle server, and its greatest advantage is that it supports more concurrent connections without adding physical resources (memory), as opposed to the dedicate approach. In other words, if you have only 2G of physical memory, and you want to support 2000 connections, you should choose MTS if you are getting the best performance.
This article first said the work of MTS, and then compared with the dedicate way to do a comparison, and then the implementation of MTS specific configuration, finally said some optimization MTS configuration options.
Ii. working methods of MTS
1. Joseph C.johnson a metaphor for the image of MTS in a restaurant.
Assuming Oracle is a restaurant, when you walk into a restaurant you feel the most comfortable service is to have a special waiter to serve you, and no matter how many people in the restaurant, she only asked you to answer, this is the dedicte way of handling, This means that each Oracle client connection has a dedicated service process to serve it. And the restaurants in the big department are not on a one-to-one basis, when you walk in, you are assigned a waiter, and she may serve other tables, which is best for restaurants because they can serve more guests without having to increase their staff. It might be good for you, too. If the restaurant is not too busy, her guests ' requests are short and easy to complete, and you feel as if you own a special waiter,waiter to transfer your order to the chef and bring you the dishes, which is how MTS is handled, These shared waiters we call them dispatchers, cooks we call them shared Server processes.
2. Describe the way MTS works (a picture in the Sybex book)
1 client sends a service request to dispatcher
2) Dispatch the request to the SGA area to the queue
3 Process the request by one or several service processes
4 The service process puts the results in the response queue of the SGA area of dispatch
5) Dispatcher picks up the result from the response queue
6 completes the client request and sends the result back to the client
MTS and dedicate ways to compare, in order to facilitate the comparison of the drawing of the following summary
Serial number
Compare items
MTS Mode
Dedicate Way
1
Service process
Multiple connections share a service process
One connection has a dedicated service process
2
The amount of memory used by each client's connection
3-4m
150-200k
3
Suitable application environment
An OLTP environment that is suitable for a large number of connections and requires a shortage
If the Oracle server has enough resources, this approach is optimized
4
CPU Load
Will cause some CPU load, if your CPU has a bottleneck, then do not use this method
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
