Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: MTS vs Dedicated connections in Web based env...

Re: MTS vs Dedicated connections in Web based env...

From: Chris Hamilton <ToneCzar_at_bellatlantic.net>
Date: 2000/06/13
Message-ID: <jincks41jjlafp3j2cemhep7nku3un6c3m@4ax.com>#1/1

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



Christopher Hamilton
Oracle DBA -- Sandbox.com
chamilton_at_sandbox-inc.com
http://www.sandbox.com/ Received on Tue Jun 13 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US