How do you setup the processes parameters in init.ora

Hi,

I have an E450 Sun Solaris box. It is 2 GB physical memory, and 4 CPUs.

I set up 2 databases on this box. My question :
How do I know the processes and sessions in both init files setup are right?

I would like to bump these parameters as high as it could. SO system can support more concurrent sessions which means more users can connect to our DB at the same time. So I won't receive max session exceed this error.

Thanks

Stacy

Set to the number that you really need, LGWR needs to scan all processes to check if it is waiting to commit.

Let's say:

Set processes=1000
session=1000

in both init files.

So how do I know the system distributes the resource efficiently?

How do I check? I mean Unix kernel setting (memory segment as well as
semophores)

Thanks

Stacy

I do not think resources are sufficient to set 1000 processes for that box. Increment it in multiples of 50 processes and monitor number of sessions in use (from v$session) and then go from there.

You can give a thought to MTS architecture in place of dedicated server architecture if you need more number of seesions to handle your application requests.