Tell me how to configure Oracle's MTS Part2

Oracle
Iv. Configuration Implementation of MTS



1. Several parameters commonly used in Oracle8i MTS environment



Serial number

Parameters

Description

1

Mts_dispatchers

Used to configure the number of dispatcher enabled when instance is started, and the protocol that dispatcher responds to, it is a dynamic parameter that can be dynamically fixed with alter system, and it has no default value.

2

Mts_max_dispatchers

Used to specify the maximum number of dispatcher processes running concurrently, for most applications, enabling one dispatcher per 250 connections can achieve better performance. The default value is 5 or the number of dispatcher configured

3

Mts_servers

Used to specify the number of service processes you want to enable when instance starts, it is a dynamic parameter that can be dynamically fixed with alter SYSTME.

4

Mts_max_servers

Used to specify the number of service processes for shared libraries at the same time, if your system is often deadlocked, you should increase this value appropriately.

5

Mts_service

Set as Sid

6

Mts_listener_address

The address that TNS listens to



2. Several parameters commonly used in Oracle9i MTS environment



Serial number

Parameters

Description

1

Dispatchers

Equivalent to the mts_dispatchers parameter in 8i

2

Max_dispatchers

Equivalent to the mts_max_dispatchers parameter in 8i

3

Shared_servers

Equivalent to the Mts_server parameter in 8i

4

Max_shared_servers

Equivalent to the mts_max_servers parameter in 8i



3, in my real Environment (Oracle8.1.7.4) For example, 9i similar, I added the following MTS parameters to init<sid> this initialization parameter file to complete the configuration of MTS.



#mts set by Qiuyb

Mts_dispatchers= "(Address= (PROTOCOL=TCP) (host=192.168.223.125)) (dispatchers=10)"

Mts_max_dispatchers=20

mts_servers=10

Mts_max_servers=50

Mts_service=billing

Mts_listener_address= "(Address= (PROTOCOL=TCP) (host=192.168.223.125) (port=1521))" large_pool_size=400m

#End of Qiuyb ' s Set



What needs to be explained is large_pool_size this initialization parameter, setting this parameter for better performance recommendations in an MTS environment so that UGA are allocated from a fixed area such as Large_pool without being dynamically allocated from the shared pool. This can also reduce the occurrence of ORA-04031 errors.



Optimizing MTS configuration options and some of the questions you might ask



1, large_pool_size This parameter I should set to how big?



When the size of the large_pool_size can meet all the shared services process required memory, of course, if enough memory can be appropriate to increase a bit, such as the following statement can be derived from the instance of the use of MTS connection to the maximum number of memory, you can see is more than 200 m.



Select sum (Value) "Max MTS Memory Allocated"

From V$sesstat SS, V$statname St

WHERE name = ' Session UGA memory Max '

and ss.statistic#=st.statistic#



Max MTS Memory Allocated

------------------------

214457296



2, how to judge the number of my dispatcher is not enough?



Using the following statement, when the busy ratio of dispatcher is over 50%, you should consider increasing the number of dispatcher, which can be accomplished with alter system dynamics.



SELECT name, (Busy/(Busy + idle)) *100 "Dispatcher% busy Rate"

From V$dispatcher



3, how to judge the shared services process is not enough?



Use the following statement to determine the average latency of each request, monitor average wait times per reques, and when this value continues to grow you should consider adding shared servers.



Select Decode (totalq,0, ' No Requests ') "Wait Time",

Wait/totalq | | ' Hundredths of seconds ' "Average wait per request"

From V$queue

WHERE type = ' COMMON '



4. How to request dedicate connection in MTS configuration server?



You can add srvr=dedicated this option when you do the service name configuration in Tnsnames.ora, as shown in the following example:

Billing =

(DESCRIPTION =

(

Address_list = (Address = (PROTOCOL = TCP) (HOST = KS3) (PORT = 1521))

)

(

Connect_data =

(service_name = billing)

(SRVR = dedicated)

)

)



Six, the knot article



Using MTS is a good option when your Oracle servers have high memory usage and frequent page changes. In general, MTS is a better fit for an OLTP type of application, and it is not suitable for those types of applications such as data warehousing and DDS.