Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: MTS vs Dedicated connections in Web based env...
On Sun, 11 Jun 2000 10:09:30 +0100, "Chris M" <chris_milner_at_hotmail.com> wrote:
>Hi,
>
>I'm about to go live with an Oracle 8i database which will be supporting up
>to 500,000 hits a day. These will mostly be selects and updates.
>
>Do I need to implement MTS? I have set up both and tried to simulate a
>thousand concurrent users and both have similar performance. But I'm not
>sure what will happen when the 'real world' begin to hammer the database. Is
>it standard for MTS to be used in this situation?
YES. My experience has been that without MTS the CPU will get saturated spawning and destroying sessions. With MTS the load is dramatically reduced.
Chris