Re: MTS

"R.A. van Geleuken" <roald_at_xs4all.nl> wrote:

>Alan Corbett wrote:
>>
>> Stupid question....I can't get Multi threaded Server to work on
>> my machine. I have all of the init.ora parms setup properly,
>> but it still won't come up.
>>
>> Can anybody provide me with some ideas?

>How about logging on with SQL*Net? I think that if you connect from the same
>machine, you get a dedicated server anyway (at least I do on our machine).

>Roald.
>--
 

>+-------------------------------------------------------+
>| R.A. van Geleuken roald_at_xs4all.nl |

 +-------------------------------------------------------+


>| There's no such thing as impossibility, only          |


>| extremely low chance                                  |

>+-------------------------------------------------------+

You need to setup SQL* Net if you want to use MTS. You can better performace for batch programs by using dedicated server processes. You can user dedicated server processes by using TWO_TASK variable or by using SRVR=DEDICATED in connect string.

Hope this helps.

--
Balakrishna Avula						28 Ashby Court
Alpha-Tek Associates Ltd.					Hemel Hempstead
Technical Consultant(on contract to Oracle UK)			HERTS HP2 7QL
100610,52 on Compuserve						UK