Re: What should be my semaphore parameter

Whatever the capacity of the Unix box is, I think it will simply collapse under the load, and the same is going to apply to Oracle. Is this a webserver?
Just a few remarks:
- You definitely need to setup the Multi-threaded server in Oracle - Oracle 7.3.4 is going to be desupported in a few months If this is a webserver you should better upgrade to Oracle 8i Enterprise edition which comes with special facilities for such huge number of connections, like connection manager, and connection pooling.

Regards

Sybrand Bakker, Oracle DBA

<pramd_at_my-deja.com> wrote in message news:8rn339$20u$1_at_nnrp1.deja.com...
> HI,
> I need to setup a database server. During peak load the Number of
> Oracle processes expected is around 40,000. The Oracle version is
> 7.3.4 on Solaris 2.6. I have a server with 12 CPUs and 9GB RAM. Can
> someone please tell me what my semmni and semmsl parameters should be.
> Should I have less semaphore sets and more semaphore/set or vice-versa.
> For such huge number of processes what is the maximum semaphores/set
> (semmsl) can I give.
>
> Thanks in advance,
> Regards
> Pramod
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Oct 07 2000 - 07:40:05 CDT