Actually it does help reduce the amount of processes on the box, thus
reducing CPU consumption. When you have Oracle set in dedicated mode it
means there is a 1 to 1 ratio of users to server processes. If you set
up MTS you will limit the number of server processes by sharing them
with the users. A good rule of thumb is 1 server process for every 10
users. So i f you have 1000 users you would only have 100 server
processes. If you keep it in dedicated mode you would have 1000 server
processes. Of course in MTS mode the users will be put in a queue, so
you have to see which method will work better for your users and
system. Have fun.
--
William Dangren
Navis Enterprises
407.348.6401
800.219.0207
Received on Sat Apr 22 2000 - 00:00:00 CDT
