Re: MTS & transaction

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 May 2002 07:16:15 +0200
Message-ID: <vvo8fukjmr4q386nhtpkgu3fjg1tmq30c2@4ax.com>

On Wed, 29 May 2002 03:06:23 GMT, Y <y_at_y.y> wrote:

>I am using Oracle 8i EE.
>
>In MTS, shared server processes switch between working for the requests
>from the user processes. These server processes work in a round-robin
>fashion.
>
>Someone would tell me WHEN a server process could switch and is ready to
>service the next request??? Is it when the server process finishes the
>whole transaction OR when the server process finishes the whole sql
>statement?
>
>TIA
AFAIK a transaction is not guaranteed to be processed by one server.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed May 29 2002 - 00:16:15 CDT