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.
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.)
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).
Originally posted by bany1 What mts param sets the raito of:
mts_dispatcher to no. of connections?
mts_server to no. of connections.?
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.
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?
Reply With Quote
Bookmarks