How to configure Oracle MTS

The following article describes how to correctly configure Oracle MTS. We all know that Oracle MTSMulti-Threaded Server is a frequently used configuration option in Oracle SERVER, compared with the DEDICATE method, it supports more concurrent connections without increasing the memory of physical resources.

In other words, if you only have 2 GB of physical memory and you want to support 2000 connections, you should select Oracle MTS for the best performance.

This article first describes how MTS works, and then compares it with the DEDICATE method. Next we will discuss the specific configuration Implementation of MTS, and finally some questions about how to optimize MTS configuration options.

How MTS works

1. Joseph C. Johnson gave an Oracle MTS image in a restaurant.

Suppose ORACLE is a restaurant. When you walk into a restaurant, the most comfortable service you feel is to have a dedicated waiter to serve you, no matter how many people come in the restaurant, she only responds to your request. This is the DEDICTE processing method. That is to say, each ORACLE client connection has a dedicated service process to serve it.

Most of the restaurants are not one-to-one. When you enter, you are assigned a waiter, which may also serve other tables, this is the most advantageous for restaurants because they can serve more guests without increasing their staff.

This may also be good for you. If the restaurant is not too busy, the requests from the guests she serves will be brief and easy to complete, you feel like you have a dedicated waiter. waiter transfers your ORDER to the cook and then delivers the prepared food to you. This is the processing method of MTS, the Shared waiters are called Dispatchers, while the chefs call them Shared Server Processes.

2. Explain how Oracle MTS works in a brief diagram (a figure in the SYBEX book)

1) the client sends a service request to Dispatcher.

2) Dispatch puts this request in the request-to-queue of the SGA Region

3) one or several service processes process the request.

4) The service process places the result in the response queue in the SGA area of the Dispatch.

5) The Dispatcher picks up the result from the response queue.

6) Complete the client request and send the result back to the client

Comparison between MTS and DEDICATE, to facilitate comparison, draw the following simple table

Serial number

Comparison item

Oracle MTS Mode

DEDICATE Method

1. Service Process

Multiple connections share a service process

A connection has a dedicated service process.

2. The amount of memory used by each client connection

3-4 M

150-200 K

3. Suitable application environment

Suitable for OLTP environments with many connections and few requests

If the Oracle server resources are sufficient, this method is preferred.

4. CPU load

It may cause some CPU load. If your CPU has a bottleneck, do not use this method.