Re: MTS

Hi Cristian,

Dispatchers parameter is the key parameter with regard to MTS. Comment it out. Other related parameters include shared_servers, shared_server_sessions, max_shared_servers, max_dispatchers and circuits (or their mts_ equivalents). All this info can be found in the Oracle reference manual.

Your errors suggest that shared_server_sessions needs to be increased as does your shared_pool_size and/or large_pool_size.

Good luck

Richard

"Cristian Veronesi" <veronesic_at_libero.it> wrote in message news:3D06FD16.8030407_at_libero.it...
> Anton Buijs wrote:
>
> > In my experience MTS is only usefull when there are > 100 concurrent
users.
>
> I configured my database (9.0.1.3 running on SuSE Linux SLES7) for MTS
> (now called Oracle Shared Server) just by answering to the MTS-related
> question posed by the Database Creation Assistant. The database is
> connected to 9iAS 1.0.2 and I'm facing a lot of "Maximum # of sessions
> exceeded" and "Unable to allocate shared memory" errors. Since I don't
> have > 100 concurrent users, I wish to try to disable MTS to see if the
> problems come out again.
>
> May you please tell me which initialization parameter(s) have I to
> change in order to (safely) disable MTS? I searched trough the Oracle
> docs but I was not able to find this info.
>
> Thanks in advance.
> Kind regards, Cristian
>
Received on Wed Jun 12 2002 - 03:51:21 CDT