Re: how to configure a shared server

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 07 Mar 2007 09:31:56 +0100
Message-ID: <45EE787C.20409@gmail.com>

Bruintje Beer schrieb:

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

Then, obviously, could you increase it to the value, which more suit your requirements ( say, 4000) and try again?

Best regards

Maxim Received on Wed Mar 07 2007 - 02:31:56 CST