Question about MTS
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question about MTS

  1. #1
    Join Date
    Dec 2000
    Posts
    10
    If I want to use MTS I need to set MTS_SERVERS =>1.
    OK this sounds logical but if I set MTS_SERVERS=5 and if there is no need for so many shared servers they stay idle, and if there are many users, Oracle server will dinamically create as much shared servers as he needs (and when busy time is gone we will have again 5 shared servers.)
    I think it is better if this parameter is TRUE/FALSE and not numerical value.


  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    You can use MTS_SERVERS=1 and MTS_MAX_SERVERS=<what_ever_you_want> to specify maximum number of MTS servers. If Oracle does not need such amount of servers so far it removes idle processes from memory.

    Sergey.

  3. #3
    Join Date
    Dec 2000
    Posts
    10
    Thanks Sergey
    That is what I did on my DB but I do not understand why would I set ever MTS_SERVERS on value bigger than 1.

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