Re: how to configure a shared server

On Tue, 6 Mar 2007 18:20:54 +0100, "Bruintje Beer" <me_at_knoware.nl> wrote:

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

How do you know the connections coming in are actually 'shared'? You also need the 'local_listener' parameter, and need to verify in v$session.server that connections are not dedicated (for idle sessions, it'll say 'none', for active 'shared'0 .......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Tue Mar 13 2007 - 11:53:28 CDT