-
MTS configuration
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.
-
-
need more explaination ...
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.)
Jeff Hunter
-
what mts param sets the ratio for ....
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).
-
Re: what mts param sets the ratio for ....
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.
Jeff Hunter
-
more mts param question
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?
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|