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 [EMAIL PROTECTED] Sent: Friday, August 16, 2002 8:43 PM How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
init.ora processes ??
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: init.ora processes ??
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: init.ora processes ??
the larger the number of processes in the init.ora, the larger the number of semaphores you need on most Unix systems. Not all, I *think* from reading the list that AIX doesn't use semaphores (I've only worked on HP-UX and SUN, both of which use semaphores) If the processes parameter is set so high that there are no more semaphores available, your database won't open --- Bob Robert [EMAIL PROTECTED] wrote: 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: init.ora processes ??
How about with Microsoft Windows NT ? --- Fink, Dan [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).