Hi,
To put ur database in Mts or dedicated server depends on how much user population u have connecting to the database.If u have more than 100 users connecting to Oracle anytime u can put ur database in MTS mode,otherwise it is better to put ur database in dedicated more.
The main difference between the 2 is that the server process is shared by many user process through dispatcher process in MTS.
So if u have around 100 users connecting then u will be needing 100 server process for 100 users and if the users are sitting idle a long time then this server process are using a lot of resources which other active users may be nedding it.
So if u use MTS then the server process gets shared by many users theryby a proper utilisation of resources is done.
In case of any prblem or queries write to me at [email protected]


Regards,
Rohit Nirkhe,Oracle DBA,OCP
[email protected]


Originally posted by eddieh
I have read all throughout Oracle's documentation that it is better to use MTS over dedicated. What kind of benchmarking tools or views can I use to compare the two configurations on my database instance?

I would like to run tests in both scenarios and see numbers which actually show me which one is better.

thanks,
-Eddie Hernandez