Re: how to configure a shared server

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 06 Mar 2007 18:47:11 +0100
Message-ID: <45EDA91F.9090805@arcor.de>

Bruintje Beer schrieb:
> "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

>
> Hi
>
> 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
>
>
>

What is the actual value of your "sessions" parameter?

Best regards

Maxim Received on Tue Mar 06 2007 - 11:47:11 CST