Re: What should be my semaphore parameter

Continuing my question again, what if the processes were less in number. How do I then assign the semmni and semmsl?? Should semmsl be as large as possible.??

Regards
Pramod

In article <970925791.8847.1.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Oct 08 2000 - 23:58:38 CDT