MTS configuration
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: MTS configuration

  1. #1
    Join Date
    Aug 2000
    Posts
    12

    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.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    tahiti.oracle.com
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Aug 2000
    Posts
    12

    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?

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Aug 2000
    Posts
    12

    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?

  6. #6
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    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).

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Aug 2000
    Posts
    12

    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?

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    tahiti.oracle.com
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width