| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: MTS in real world?
1443131_at_usenetplanet.com wrote in message news:<3bf126af.49203110_at_tornado.usenetplanet.com>...
> I have been in a number of companies, but have not been in a single
> place where Oracle database is configured with MTS mode. I have been
> told all along that MTS mode causes a lot of problems (even with
> Oracle's own Oracle Financial applications). Is this true? If so,
> what kind of problems have you experienced? Thank you in advance.
It depends on the versions you are using. Oracle is shifting more and more to shared servers as the default connection. In cluster databases it is very convenient to use MTS to enable serverbased load balancing. In case you shift from dedicated to shared servers, don't forget to increase the sga by an amount equal to the sum of the pga's.
Ronald.
 |
 |