Without being flip, there is some serious analysis you should do before
creating a server to support 3000 (concurrent?) users. You need to have
model or workload characterization. Based on that, you should estimate how
much iron you would need to make it work. If you can support the processing
and IO, you next should review Oracle characteristics. A big choice is MTS
or not. You might even consider a proxy out of Oracle, for example if your
connections are from a middleware server. If you post a more detailed sense
of what you need, I think the list will be able to find matching instance
configurations.

/Aaron

----- Original Message -----
From: "Regis Biassala" <Regis.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Wednesday, March 31, 2004 8:31 AM
Subject: RE: Max number of users in Oracle 9i?


> SGA --- I don't know, depends on your memory(RAM)
> PROCESSES = 3010 (init.ora processes = 3000 users + 10 for background
> processes)
> set semsys:seminfo_semmns=3000 users + 10 background process + 20 extra
> semaphores
>
>
> example of what I have on one of my solaris box:
>
> --- oracle 10g, oracle9iR2, oracle8i
> --- 6 databases running.
> --- This is a development machine
> set noexec_user_stack=1
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmni=500
> set semsys:seminfo_semmsl=500
> set semsys:seminfo_semmns=1024
> set semsys:seminfo_semopm=500
> set semsys:seminfo_semvmx=32767
> set semsys:seminfo_semmap=250
> set semsys:seminfo_semmnu=500
> set semsys:seminfo_semume=100
>
> NOTE: set noexec_user_stack=1 is required for 10g
>
> I hope this helps,
> Regis
>
> -----Original Message-----
> From: Thoka, Radhakrishna (GE Transportation, non-ge)
> [mailto:radhakrishna.[Email Address Removed] Sent: 31 March 2004 14:13
> To: LazyDBA.com Discussion
> Subject: Max number of users in Oracle 9i?
>
> Hi Folks,
>
>
> I'm going to install and create instance Oracle 9i on brand new Unix box
Sun
> Solaris.
>
> I have couple of questions in my mind,
>
> to create the maximum no of users letz say 3000 Users in my database.how
> much SGA required?
>
> What are the suggested values for Semaphores....
>
> Please gimme if you have any link....
>
> Regards
> Krishna
> *********************************************************************
> This electronic transmission is strictly confidential and intended solely
> for the addressee. It may contain information which is covered by legal,
> professional or other privilege. If you are not the intended addressee,
> you must not disclose, copy or take any action in reliance of this
> transmission. If you have received this transmission in error,
> please notify the sender as soon as possible.
>
> This footnote also confirms that this message has been swept
> for computer viruses.
> **********************************************************************
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
Oracle LazyDBA home page