Re: what advantage for using MTS

Think of it this way.

I fire up SQL Plus. I thereby obtain a dedicated server process, together with a private bit of memory space (the PGA). I then go for a smoke break. Oh, then I go for lunch, take in a bit of shopping, have a snooze on a park bench, and eventually come back to the office for a bit of a natter with the office floozies. Finally, about 4 hours later, I issue my long-awaited SQL command (inevitably, 'select * from emp') and do some real work on the server.

For X hours, my server process has been sitting doing squat diddly, and chewing up CPU cycles and (more importantly) swathes of scarce memory to boot.

That's exactly what MTS is designed to avoid (if *I* don't stress a shared server process, someone else likely will). Wasted resources.

It's also probably the only way you'll get hundreds of concurrent users connected to your server, unless you have shares in a Taiwanese silicon foundry.

I've actually swung in my opinions in the past few months. I've come to the conclusion that you need a really good reason *Not* to be running MTS, given that even under an MTS setup, DBAs and people with heavy needs can acquire a dedicated server connnection when they need to.

Regards
HJR "Peter Ho" <hoo311_at_ctimail3.com> wrote in message news:9i7ljl$5591_at_rain.i-cable.com...
> Dear all,
>
> What advantage for using MTS? If the purpose of my oracle 8i is for web
> users access, can MTS provide a better performance?
>
>
> Peter
>
>
Received on Sat Jul 21 2001 - 16:32:24 CDT