Re: init.ora processes ??

Another thing to consider is this:

>From OraPerf:

    The LGWR needs to scan all processes to find each process that is waiting for the commit to be written.

So when you have an excess of process LGWR works harder.

Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, August 16, 2002 8:43 PM

> How about with Microsoft Windows NT ?
> --- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> > For each process 'reserved' by oracle, there is a
> > small amount of space
> > allocated in the SGA and a semaphore is reserved at
> > the O/S level (assuming
> > UNIX). A lesser number of processes will allocate a
> > slightly smaller amount
> > of SGA and fewer semaphores. Until a session is
> > started, no other memory is
> > allocated.
> >
> > Dan Fink
> >
> > -----Original Message-----
> > Sent: Friday, August 16, 2002 10:44 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > All,
> >
> > What is the impact of "processes" init.ora parameter
> > other than restricting number of user sessions ? I
> > know it needs more memory (like stack size + sort
> > area
> > size + etc. ) whenever it gets new connection.
> >
> > My question is:
> > Is there any additional resource (does it take more
> > memory? ) usage if I start database with 100
> > processes
> > versus 200 processes as init.ora parameter (assuming
> > that I have same number of sessions in both cases).
> >
> > Thanks for your help.
> >
> > Bob
> >
> > __________________________________________________
> > Do You Yahoo!?
> > HotJobs - Search Thousands of New Jobs
> > http://www.hotjobs.com
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Bob Robert
> > INET: mssql_2002_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Fink, Dan
> > INET: Dan.Fink_at_mdx.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX:
> > (858) 538-5051
> > San Diego, California -- Public Internet
> > access / Mailing Lists
> >
> --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an
> > E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of
> > 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB
> > ORACLE-L
> > (or the name of mailing list you want to be removed
> > from). You may
> > also send the HELP command for other information
> > (like subscribing).
>
>
> __________________________________________________
> Do You Yahoo!?
> HotJobs - Search Thousands of New Jobs
> http://www.hotjobs.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bob Robert
> INET: mssql_2002_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).