Citation:
A dedicated server connection consumes an OS process. Each process has its own PGA. Using MTS serves three primary purposes:
o process reduction, less context switching between OS level processes in the OS itself
o slight memory reduction, by removing the now redundant PGA allocations
o maximum active session control -- you'll never have more then N active
sessions where N = max shared servers. If all 1,232 users hit the "go" button using dedicated server -- the machine would fall over, get swamped. Using MTS, some would just wait a tad longer then others but everything would proceed in an organized manner.
Dans son livre Oracle Efficient by Design, il conseille d'utiliser MTS uniquement si on est sûr que le mode serveur dédié serait beaucoup trop lent. Idéalement, il faudrait tester.