Re: processes

Daud wrote:
>
> What's the impact of having large number for processes (init
> parameter) other than allowing more connections to oracle? I am used
> to setting it around 500. However, for this one particular app I am
> gonna have to set it to more than 2000 to support 400 clients because
> each client can at any one time opens up 5 connections. I am just not
> such what's the impact.
>
> In HPUX 11.0, do I need to set SEMMSL? I dont seem to be able to find
> that kernal parameter.
>
> rgds
> Daud

I think LGWR scans a structure that is sized based on the processes parameter, thus having it set excessively larger that what is really required could be a performance inhibitor

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."