Re: how to configure a shared server

From: Bruintje Beer <me_at_knoware.nl>
Date: Wed, 7 Mar 2007 06:25:20 +0100
Message-ID: <45ee4cb5$0$719$5fc3050@dreader2.news.tiscali.nl>

"Maxim Demenko" <mdemenko_at_arcor.de> schreef in bericht news:45EDA91F.9090805_at_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

number of sessions is 170

John Received on Tue Mar 06 2007 - 23:25:20 CST