Re: optimizer and MTS

From: sybrandb <sybrandb_at_gmail.com>
Date: Tue, 26 Jun 2007 01:05:41 -0700
Message-ID: <1182845141.770564.113880@g4g2000hsf.googlegroups.com>

On Jun 25, 11:11 pm, wagen..._at_yahoo.com wrote:
> Oracle 9.2.x
> solaris 2.7
>
> Does MTS in anyway influence the optimizer?
>
> I think the answer is NO, but just wanted to get some input.
>
> Thanks
> wagen

The answer is NO. MTS is just a connection mechanism. Be aware though you can't trace a MTS connection, as there is no guarantee the entire session will be executed by one shared server process.

--
Sybrand Bakker
Senior Oracle DBA

Received on Tue Jun 26 2007 - 03:05:41 CDT