All,
could someone give some pointer on configuring MTS on 9i Release 2. Please also explain how shared pool size and large pool size are being use relative to MTS and Dedicated. Thanks.
Printable View
All,
could someone give some pointer on configuring MTS on 9i Release 2. Please also explain how shared pool size and large pool size are being use relative to MTS and Dedicated. Thanks.
tahiti.oracle.com
hmm, got some answer via oracle docs but still have questions. Here's What I think large pool is in regards to MTS, it's used to cache processes sort area which are connected as shared server processes. shared pool are shared sql area and pl/sql.
as for as configuration,
mts_session is ratio of dispatcher to no. of connection.
still don't know diff between:
mts_dispatcher and mts_server. What function does mts_server servererd?
Think of the dispatcher as the traffic cop who tells the requests which shared server to go to. The shared server is the process that does the work on behalf of the user. There are a limited number of shared servers in an MTS configuration and each is shared by all users using MTS. In a dedicated server environment each session that gets established gets one process on the server. There are advantages and advantages to using MTS; choose wisely. (Note: an instance can be configured with shared server and dedicated servers.)
What mts param sets the raito of:
mts_dispatcher to no. of connections?
mts_server to no. of connections.?
show parameters mts, list:
mts_circuits integer 665
mts_dispatchers string (PROTOCOL=TCP) (SERVICE=prodXD
B)
mts_listener_address string
mts_max_dispatchers integer 5
mts_max_servers integer 20
mts_multiple_listeners boolean FALSE
mts_servers integer 1
mts_service string prod
mts_sessions integer 660
Any idea?
You need to think carefully about the sizing of your SGA when chosing MTS... UGA is stored in the SGA in MTS and stored in separate PGA in dedicated. Only use MTS if you HAVE to (in my humble opinion).
every environment is different. For my environment, I use 2 dispatchers and 10 shared servers. You have to monitor the MTS v$ views to see if anybody is waiting.Quote:
Originally posted by bany1
What mts param sets the raito of:
mts_dispatcher to no. of connections?
mts_server to no. of connections.?
what param set the ratio of number of connection to dispatcher? What param set the ratio of sessions to mts server param? What param set pooling on or multiplex on? Where can I view the param?
tahiti.oracle.com