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.
**********************************************************************

Oracle LazyDBA home page