How do you setup the processes parameters in init.ora
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.
Set to the number that you really need, LGWR needs to scan all processes to check if it is waiting to commit.
Oracle Certified Master - September, 2003, the Second OCM in China
*** LOOKING for PART TIME JOB***
Data Warehouse & Business Intelligence Expert
MCSE, CCNA, SCJP, SCSA from 1998
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
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.
Click Here to Expand Forum to Full Width