Re: how to configure a shared server

From: Bruintje Beer <me_at_knoware.nl>
Date: Tue, 6 Mar 2007 18:20:54 +0100
Message-ID: <45eda2eb$0$754$5fc3050@dreader2.news.tiscali.nl>

"Maxim Demenko" <mdemenko_at_arcor.de> schreef in bericht news:45ED98FD.2030509_at_arcor.de...
> Bruintje Beer schrieb:
>> Hi,
>>
>> How do I configure a shared server using connection pooling. What
>> parameters need to be changed to run a shared server using connection
>> pooling.
>>
>> John
>
> http://download-uk.oracle.com/docs/cd/B19306_01/network.102/b14212/dispatcher.htm#sthref1163
>
> Best regards
>
> Maxim

I tried

ALTER SYSTEM SET DISPATCHERS="(PROTOCOL=tcp)(DISPATCHERS=1)(POOL=on)(TICK=1) (CONNECTIONS=950)(SESSIONS=4000)" SCOPE=SPFILE and restarted oracle but did not work

I can only make 145 connections

This is very difficult to achieve in oracle. How to configure connection pooling / shared server to accept a lot of clients

John Received on Tue Mar 06 2007 - 11:20:54 CST